crystaldba/postgres-mcp
MITAPI key required🐍 🏠 - All-in-one MCP server for Postgres development and operations, with tools for performance analysis, tuning, and health checks
Install
npx -y crystaldba-postgres-mcpRequired environment variables
OPENAI_API_KEYSet in your MCP configclaude_desktop_config.json
{
"mcpServers": {
"crystaldba-postgres-mcp": {
"command": "npx",
"args": [
"-y",
"crystaldba-postgres-mcp"
],
"env": {
"OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>"
}
}
}
}Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.
What this does
crystaldba/postgres-mcp exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation. That makes it useful when you want Claude to reach into your databases without copy-pasting context every turn.
Requirements
This server needs the following environment variables to be set before it can run:
OPENAI_API_KEY
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Common use cases
- •Query structured data without writing SQL by hand
- •Let Claude read table schemas before answering data questions
- •Run read-only operational reports or sanity checks during incidents
More Python MCP servers
microsoft/markitdown
🎖️ 🐍 🏠 - MCP tool access to MarkItDown -- a library that converts many file formats (local or remote) to Markdown for LLM consumption.
mindsdb/mindsdb
Connect and unify data across various platforms and databases with .
FastMCP
🐍 - A high-level framework for building MCP servers in Python
oraios/serena
🐍 🏠 - A fully-featured coding agent that relies on symbolic code operations by using language servers.