MCP Database Server

What it does

The MCP Database Server allows AI models to interact directly with various relational databases. It bridges the gap between LLMs and structured data, enabling the AI to read, write, and manage schemas across different database engines.

Tools

• read_query: Execute SELECT queries to read data.
• write_query: Execute INSERT, UPDATE, or DELETE queries.
• create_table: Create new tables in the database.
• alter_table: Modify existing table schema.
• drop_table: Remove a table from the database.
• list_tables: Get a list of all tables.
• describe_table: View schema information for a table.
• export_query: Export query results as CSV/JSON.
• append_insight: Add a business insight to memo.
• list_insights: List all business insights.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "database-server": {
      "command": "npx",
      "args": [
        "-y",
        "@executeautomation/database-server",
        "--postgresql",
        "--host", "your-host",
        "--database", "your-db",
        "--user", "your-user",
        "--password", "your-pass"
      ]
    }
  }
}

(Replace flags with --sqlite, --sqlserver, or --mysql as needed)

Supported hosts

• Claude Desktop