db-mcp-server

Overview

The DB MCP Server is a powerful Go-based implementation that allows AI models to interact with multiple databases simultaneously through the Model Context Protocol. It supports lazy loading for efficient resource management, database-specific tool generation, and follows clean architecture principles. The server provides standardized tools for SQL queries, transaction management, schema exploration, and performance analysis across different database systems.

Try asking AI

After installing, here are 6 things you can ask your AI assistant:

• query_<db_id>

  Execute SELECT queries and get results as a tabular dataset

  Try:Select all users from the customers table where age is greater than 30Try:Show me the top 10 products by sales revenueTry:Find all orders placed in the last 7 days
• execute_<db_id>

  Run data manipulation statements (INSERT, UPDATE, DELETE)

  Try:Insert a new user with name John Doe and email john@example.comTry:Update the price of product ID 123 to $99.99Try:Delete all orders from customer ID 456
• transaction_<db_id>

  Begin, commit, and rollback transactions

  Try:Start a transaction to transfer $100 from account A to account BTry:Commit the current transactionTry:Rollback the current transaction due to an error
• schema_<db_id>

  Get information about tables, columns, indexes, and foreign keys

  Try:Show all tables in the databaseTry:Describe the columns of the orders tableTry:List all indexes on the customers table
• generate_schema_<db_id>

  Generate SQL or code from database schema

  Try:Generate SQL CREATE TABLE statements for all tablesTry:Generate TypeScript interfaces for the database schemaTry:Create a migration script to add a new column
• performance_<db_id>

  Analyze query performance and get optimization suggestions

  Try:Analyze the performance of this query: SELECT * FROM orders WHERE date > '2023-01-01'Try:Find the slowest queries in the databaseTry:Get optimization suggestions for the customers table

Comparable tools

Installation

docker pull freepeak/db-mcp-server:latest
docker run -p 9092:9092 \
  -v $(pwd)/config.json:/app/my-config.json \
  -e TRANSPORT_MODE=sse \
  -e CONFIG_PATH=/app/my-config.json \
  freepeak/db-mcp-server

git clone https://github.com/FreePeak/db-mcp-server.git
cd db-mcp-server
make build
./bin/server -t sse -c config.json

{
  "mcpServers": {
    "db-mcp-server": {
      "command": "path/to/db-mcp-server/server",
      "args": ["-t", "stdio", "-c", "/path/to/config.json"]
    }
  }
}

FAQ

What databases are supported?

The server supports MySQL, PostgreSQL, SQLite, Oracle, and TimescaleDB with full functionality for queries, transactions, schema analysis, and performance insights.

Can I connect to multiple databases simultaneously?

Yes, the server is designed to connect to multiple databases concurrently, each with their own connection configuration and dynamically generated tools.

What transport modes are available?

The server supports both STDIO mode for IDE integration and SSE mode for server-client communication over HTTP.

Compare db-mcp-server with