Database MCP Server, developed by Legion AI, enables AI assistants to access and query data across multiple database types (PostgreSQL, MySQL, SQL Server, BigQuery, etc.) through a standardized interface. Built with Python using the Legion Query Runner library, it exposes database operations as MCP tools and resources, allowing natural language interactions with databases for executing queries, retrieving schemas, and optimizing SQL statements. The implementation features flexible configuration options and maintains query history for context, making it particularly valuable for data analysis, business intelligence, and database exploration use cases where AI assistants need direct, controlled access to structured data.
まだレビューはありません. 最初のレビューを投稿しましょう!
会話に参加するにはサインインしてください
Execute a SQL query and return results as a markdown table. Requires a `db_id` to specify the database.
Execute a SQL query and return results as JSON. Requires a `db_id` to specify the database.
Get column names for a specific table. Requires a `db_id` to specify the database.
Get column types for a specific table. Requires a `db_id` to specify the database.
Get the recent query history for the connected database.
List all available database connections.
Get detailed information about a database including schema. Requires a `db_id` to specify the database.
Find which database contains a specific table. Requires a `db_id` to specify the database.
Get detailed description of a table including column names and types. Requires a `db_id` to specify the database.
Get a sample of data from a table. Requires a `db_id` to specify the database.
Create an SQL query against the database.
Explain what a SQL query does.
Optimize a SQL query for better performance.
Help user select which database to use.