Database MCP

What it does

Connects AI assistants to a wide range of SQL databases, allowing the AI to explore schemas and execute queries across MySQL, MariaDB, PostgreSQL, and SQLite.

Tools

• listDatabases: Lists accessible databases (excluding SQLite).
• listTables: Lists tables in a database with optional detailed metadata.
• listViews: Lists database views.
• listTriggers: Lists user-defined triggers.
• listFunctions: Lists user-defined SQL functions.
• listProcedures: Lists stored procedures.
• listMaterializedViews: Lists PostgreSQL materialized views.
• readQuery: Executes read-only SQL queries (SELECT, SHOW, etc.).
• writeQuery: Executes data-modifying queries (INSERT, UPDATE, DELETE).
• createDatabase: Creates a new database.
• dropDatabase: Removes an existing database.
• dropTable: Removes a specific table.
• explainQuery: Provides the SQL execution plan.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "dbmcp": {
      "command": "dbmcp",
      "args": ["stdio"],
      "env": {
        "DB_BACKEND": "mysql",
        "DB_HOST": "127.0.0.1",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "secret",
        "DB_NAME": "mydb"
      }
    }
  }
}

Supported hosts

• Claude Desktop
• Cursor