# mcp-alchemy

> MCP Server

MCP Alchemy connects Claude Desktop to databases, enabling it to explore database structure, write SQL queries, display relationships, and analyze large datasets using SQLAlchemy-compatible databases. MCP Alchemy connects Claude Desktop

## Overview

- **Category:** Database
- **Language:** Python
- **Stars:** 414
- **Forks:** 11
- **Owner:** runekaagaard
- **GitHub:** https://github.com/runekaagaard/mcp-alchemy
- **Created:** 2024-12-26T14:09:30+00:00
- **Updated:** 2025-03-28T18:17:57+00:00
- **Source:** https://model-context-protocol.com/servers/mcp-database-access-llm-sql-alchemy

## Setup

## Setup

1. Clone repository:
```bash
git clone https://github.com/runekaagaard/mcp-alchemy.git
```

2. Ensure you have uv
```bash
# Install uv if you haven't already
curl -LsSf https://astral.sh/uv/install.sh | sh
```

3. Add database to claude_desktop_config.json (see above)

## Tools

## Available Tools

1. **all_table_names** (Return all table names in the database)
2. **filter_table_names** (Find tables matching a substring)
3. **schema_definitions** (Get detailed schema for specified tables)
4. **execute_query** (Execute SQL query with vertical output format)
5. **claude-local-files** (Analyse and create artifacts for very large datasets)