legion-mcp
If you are the rightful owner of legion-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.
This tool is provided by Legion AI. To use the full-fledged and fully powered AI data analytics tool, please visit the site. Email us if there is one database you want us to support.
The Multi-Database MCP Server by Legion AI is a powerful server designed to facilitate access and querying of data across multiple databases using the Legion Query Runner. It integrates the Model Context Protocol (MCP) Python SDK to enable seamless AI assistant interactions. This server provides a unified interface for connecting to various databases such as PostgreSQL, MySQL, SQL Server, and more, through a consistent API. It is particularly beneficial for AI applications, offering features like zero-configuration schema discovery, secure credential management, and extensible design. The server supports multiple deployment options and is compatible with modern AI development environments, making it a versatile solution for developers looking to streamline database operations and reduce complexity.
Features
- Multi-database support - connect to multiple databases simultaneously
- Database access via Legion Query Runner
- Model Context Protocol (MCP) support for AI assistants
- Expose database operations as MCP resources, tools, and prompts
- Multiple deployment options (standalone MCP server, FastAPI integration)
Tools
execute_query
Execute a SQL query and return the result as a Markdown table
execute_query_json
Execute SQL query and return the result as JSON
get_table_columns
Get the column name of a specific table
get_table_types
Get the column type of a specific table
get_query_history
Get the latest query history
