Mcp Alchemy

general MCP 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.

Install Ready
generalgeneralpostgresqlmysql
17 views410 stars62 forksMPL-2.0

Why This Matters

Discovered via unknown and last synced 3mo ago.

Install Ready
Source
unknown
Stars
410
Last synced
3mo ago
Install
Instructions detected

Install

1. Install the package

uvx --from mcp-alchemy==2025.8.15.91819 --refresh-package mcp-alchemy mcp-alchemy

2. Add to claude_desktop_config.json

{
  "mcpServers": {
    "mcp-alchemy": {
      "command": "uvx",
      "args": [
        "--from",
        "mcp-alchemy==2025.8.15.91819",
        "--refresh-package",
        "mcp-alchemy",
        "mcp-alchemy"
      ]
    }
  }
}

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)

18
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (18)

Returns

results in clean vertical format:

Primary

keys

filter_table_names

Find tables matching a substring

Foreign

key relationships

Clean

NULL value display

Clear

row separation

No

input required

Features

Smart truncation of large results

Nullable

flags

all_table_names

Return all table names in the database

Column

names and types

Full

result set access via [claude-local-files](https://github.com/runekaagaard/claude-local-files) integration

Input

`table_names` (string[])

execute_query

Execute SQL query with vertical output format

params

(object, optional): Query parameters

Inputs

`query` (string): SQL query

ISO

formatted dates

schema_definitions

Get detailed schema for specified tables