MCP Alchemy
by runekaagaard
MCP Alchemy connects Claude Desktop directly to your databases, allowing it to explore database structure, assist in writing SQL queries, and analyze large datasets. It works with various SQLAlchemy-compatible databases like PostgreSQL, MySQL, and SQLite.
Last updated: N/A
What is MCP Alchemy?
MCP Alchemy is a tool that integrates Claude Desktop with various databases, enabling Claude to interact with and analyze database content.
How to use MCP Alchemy?
To use MCP Alchemy, you need to add it to your claude_desktop_config.json file, specifying the database driver and connection details. The README provides examples for different databases like SQLite, PostgreSQL, MySQL, and others. You also need to ensure you have uv installed.
Key features of MCP Alchemy
Database exploration and understanding
SQL query assistance and validation
Relationship visualization between tables
Large dataset analysis and report generation
Integration with claude-local-files for large datasets
Use cases of MCP Alchemy
Exploring and understanding database schemas
Generating SQL queries for data retrieval and manipulation
Analyzing large datasets to identify trends and insights
Creating reports and visualizations based on database content
FAQ from MCP Alchemy
What databases are supported?
What databases are supported?
MCP Alchemy supports PostgreSQL, MySQL, MariaDB, SQLite, Oracle, MS SQL Server, CrateDB, and other SQLAlchemy-compatible databases.
How do I configure MCP Alchemy for my database?
How do I configure MCP Alchemy for my database?
You need to add a configuration block to your claude_desktop_config.json file, specifying the appropriate database driver and connection string in the DB_URL environment variable. Examples are provided in the README for various databases.
What is claude-local-files and how does it integrate?
What is claude-local-files and how does it integrate?
claude-local-files allows access to complete result sets beyond Claude's context window. The integration automatically activates when CLAUDE_LOCAL_FILES_PATH is set.
What environment variables are available?
What environment variables are available?
The available environment variables are DB_URL (required), CLAUDE_LOCAL_FILES_PATH (optional), and EXECUTE_QUERY_MAX_CHARS (optional).
What tools are available in the API?
What tools are available in the API?
The API provides tools like all_table_names, filter_table_names, schema_definitions, and execute_query for interacting with the database.