database-mcp
If you are the rightful owner of database-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A MCP (Metoro Control Protocol) service with database capabilities, supporting multiple database types through GORM.
The Database MCP Service is a robust Metoro Control Protocol (MCP) server that integrates with various database systems using GORM, a popular ORM library for Go. It supports multiple database types including MySQL, PostgreSQL, SQLite, SQL Server, and ClickHouse, providing flexibility for different application needs. The service allows configuration through a YAML file, command line arguments, or environment variables, making it adaptable to various deployment environments. With MCP protocol integration, it facilitates seamless communication and control over database operations. The service is designed to initialize database connections, start an MCP server, and register available tools and resources, ensuring efficient database management and operations.
Features
- Support for multiple database types: MySQL, PostgreSQL, SQLite, SQL Server, ClickHouse
- Configuration through YAML file, command line arguments, and environment variables
- MCP protocol integration for seamless communication
- GORM ORM support for database operations
Tools
get_tables
Get all tables in the database, returns a list of tables with their names and comments
get_table_detail
Get detailed information about a specific table, including column information
execute_sql
Execute a SQL query, returns results for SELECT queries or number of rows affected for other queries