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` parameter to specify which database to use.
Execute a SQL query and return results as JSON. Requires a `db_id` parameter to specify which database to use.
Get column names for a specific table. Requires a `db_id` parameter to specify which database to use.
Get column types for a specific table. Requires a `db_id` parameter to specify which database to use.
Get the recent query history.
List all available database connections.
Get detailed information about a database including schema. Requires a `db_id` parameter to specify which database to use.
Find which database contains a specific table. Requires a `db_id` parameter to specify which database to use.
Get detailed description of a table including column names and types. Requires a `db_id` parameter to specify which database to use.
Get a sample of data from a table. Requires a `db_id` parameter to specify which database to use.
No reviews yet. Be the first to review!
Sign in to join the conversation
