DBHub MCP Server: Setup for Claude, Cursor and Other Apps

• Runs SQL statements on your database

  Runs one or more SQL statements, including inserts, updates and deletes, and can wrap them in a transaction. It can be limited to read-only queries and a row cap in the config file.

  Try: “Show the 10 most recent signups from the users table.”

  Delete · execute_sql

• Finds schemas, tables, columns, indexes and procedures

  Searches the database structure by name pattern, from a short list of names up to full details. It returns only as much as you ask for, to save space.

  Try: “Which tables have a column named customer_id?”

  Read · search_objects

• Shows how the database would run a query, without running it

  Returns the execution plan for one SQL statement and never executes it. It is off by default and must be turned on in the config file.

  Try: “Explain the plan for this slow join.”

  Read · explain_sql

• Reports connection counts and cache hit ratio

  Shows how many sessions are open, idle or stuck, and how often reads come from cache. It works on PostgreSQL, MySQL, MariaDB, SQL Server and Oracle, and is off by default.

  Try: “Is our Postgres connection pool close to its limit?”

  Read · health_check

Watch out for

• It can change or delete data by default

  The SQL tool runs any statement unless you set read-only mode in the config file. Connect with a database user that has only the rights you want the assistant to have. github.com

• Network mode listens on every interface

  With the HTTP transport, the default address is 0.0.0.0 and auth is off unless you set a token. Use a local address such as 127.0.0.1 or set a token. github.com

• Password sits in the connection string

  The database password is part of the DSN you put in your client config. Keep that file private, or use the config file with ${VAR} values. github.com

Security advisories