Database MCP Server

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.