MCP Alchemy
About This Server
A 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.
Server Information
This webpage is the GitHub repository for "mcp-alchemy," a Model Context Protocol (MCP) server that facilitates Large Language Model (LLM) access to relational databases. It supports various databases including SQLite, PostgreSQL, MySQL, MariaDB, Oracle, and MS-SQL. The repository provides installation instructions, configuration details for Claude Desktop integration, API tool descriptions, contribution guidelines, and licensing information under the Mozilla Public License Version 2.0.
ā Key Points:
- MCP Alchemy connects LLMs to relational databases.
- It supports multiple database systems through SQLAlchemy.
- It includes tools for schema exploration, query execution, and result analysis.
- Integration with Claude Desktop is emphasized for enhanced database interaction using LLMs.
- The project is open to contributions and licensed under MPL-2.0.
- The project's status is reported to be stable and in daily use.
- API includes alltablenames, filtertablenames, schemadefinitions, and executequery tools.
- The project provides detailed steps for integration with Claude Desktop including configuration settings and environment variables.
- Instructions for installing additional database drivers beyond the defaults (SQLite, MySQL/MariaDB, PostgreSQL) are provided.
- Integration with claude-local-files enhances LLM's ability to access full dataset results and generate reports.
- Database support is achieved through SQLAlchemy, requiring appropriate database drivers.
- Environment variables such as DBURL, CLAUDELOCALFILESPATH, and EXECUTEQUERYMAX_CHARS can be configured.
- Instructions detail cloning the repository and installing uv package manager and setting up claudedesktopconfig.json.
- The GitHub repository contains files like README.md, LICENSE, server.py, and configuration files.
- The project has 53 stars and 5 forks.
š Main Findings:
š Details:
šÆ Conclusion:
The mcp-alchemy repository provides a functional MCP server designed to bridge LLMs and relational databases, primarily for enhancing interactions with Claude Desktop. The repository is well-documented, open for contributions, and offers tools to help manage database access and analysis within an LLM context.
Server Features
all_table_names
Return all table names in the database
filter_table_names
Find tables matching a substring
schema_definitions
Get detailed schema for specified tables
execute_query
Execute SQL query with vertical output format
Provider Information
Runekaagaard
cloud Provider