MCP Alchemy

MCP Alchemy

PythonDatabaseSqlSqlitePostgresqlMysqlMariadbOracleMsSqlLlmMcpJavascriptGoRubyR

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

šŸ“‹ Overview:

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.


  • šŸ” Main Findings:
  • 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.


  • šŸ“Š Details:
  • 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.


šŸŽÆ 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 logo

Runekaagaard

cloud Provider

Visit Provider Website

Quick Actions

Visit Website

MCP Configuration

Available Tools

all_table_namesfilter_table_namesschema_definitionsexecute_query