Database Mcp

What is Database Mcp?

Database Mcp is an MCP (Model Context Protocol) service that provides database capabilities through GORM, supporting multiple database types including MySQL, PostgreSQL, SQLite, SQL Server, and ClickHouse. It is intended for developers who want to integrate database operations into MCP-compatible clients.

How to use Database Mcp?

Clone the repository, run go mod tidy to install dependencies, then start the service with ./database-mcp. Configure the database connection via a YAML config file, command line arguments, or environment variables. Connect your MCP client to the SSE endpoint at http://127.0.0.1:8080/sse to use the provided tools.

Key features of Database Mcp

• Supports MySQL, PostgreSQL, SQLite, SQL Server, and ClickHouse databases.
• Configuration via YAML file, command line arguments, or environment variables.
• Provides three MCP tools: get_tables, get_table_detail, and execute_sql.
• Uses GORM ORM for database interactions.
• Exposes an SSE endpoint on port 8080 for MCP client integration.

Use cases of Database Mcp

• Querying database schema and table details from an MCP client.
• Executing read and write SQL queries through MCP tools.
• Managing multiple database types with a unified configuration interface.
• Automating database exploration and analysis in MCP-enabled applications.

FAQ from Database Mcp

What database types does Database Mcp support?

It supports MySQL, PostgreSQL, SQLite, SQL Server, and ClickHouse.

How can I configure the database connection?

You can configure it using a YAML config file (config.yaml), command line arguments, or environment variables. Command line arguments override file settings.

What tools does Database Mcp provide?

It provides get_tables (list all tables), get_table_detail (get column info for a specific table), and execute_sql (run any SQL query, returning results or affected row count).

How do I connect an MCP client to Database Mcp?

Configure your MCP client to use the SSE endpoint at http://127.0.0.1:8080/sse.

What are the runtime requirements?

You need Go installed to build from source, and a supported database (MySQL, PostgreSQL, SQLite, SQL Server, or ClickHouse) accessible from the service.