Database Mcp
@xavieryang007
Database Mcp について
# Database MCP Service
基本情報
設定
ツール
ツールは検出されませんでした
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
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, andexecute_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.
「データベース」の他のコンテンツ
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Snowflake MCP Server
isaacwassermanMySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
コメント