PostgreSQL MCP
About
A Model Context Protocol (MCP) server that provides AI assistants (like Claude) with tools to directly interact with PostgreSQL databases securely.
Details
- Author
- udaykumar-dhokia
- Categories
- Database, Other, AI, Developer Tools
Jump to
Setup
Install PostgreSQL MCP in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/udaykumar-dhokia/postgresql-mcp
Follow the installation instructions in the repository README, then restart your MCP client.
A Model Context Protocol (MCP) server that provides AI assistants (like Claude) with tools to directly interact with PostgreSQL databases securely.
- create_table: Create a new table with custom columns.
- list_tables: List all tables in the public schema.
- describe_table: Get the schema and column details of a specific table.
- execute_sql: Execute arbitrary SQL queries.
- Web Configurator: A built-in local web UI to securely manage connection strings and generate API keys.
You can install and run this package easily usinguv:
# Run without installing globally uvx postgresql-mcp # Or install globally for easy access uv tool install postgresql-mcp
This project requires an API Key mapped to your PostgreSQL database URL. To easily set this up, we provide a built-in Web Configurator.
Or, if running without global installation:
Open your browser tohttp://localhost:8000. Enter your database URL (postgresql://user:pass@host/db) and click "Generate API Key".
The application securely stores your credentials in~/.sql-mcp/keys.jsonand outputs a configuration snippet.
Copy the generated snippet and add it to your Claude Desktop configuration file (typically located at%APPDATA%\Claude\claude_desktop_config.jsonon Windows or~/Library/Application Support/Claude/claude_desktop_config.jsonon macOS).
{ "mcpServers": { "postgresql-mcp": { "command": "uvx", "args": [ "postgresql-mcp" ], "env": { "API_KEY": "postgresql-mcp-your-generated-key" } } } }
Restart Claude Desktop, and your AI assistant will now be able to interact with your database!
The server automatically tracks how many times each API key is utilized. You can view this data locally in~/.sql-mcp/usage.json.
We welcome contributions! Please seeCONTRIBUTING.mdfor details on how to get started.
A Claude Kubernetes MCP server, built in Go. The server integrates with ArgoCD, GitLab, Claude AI, and Kubernetes to enable advanced control and automation of Kubernetes environments.
The all-seeing guardian for macOS: Battery, Clipboard, TTS, and File System control using Claude desktop
Deterministic code-graph (GraphRAG) over your repo for LLM agents — local-first, git-native, zero-infra, served via MCP.
614 million contacts, live SMTP-verified. Invalid emails cost you $0. Connect Argorant with any Agent through CLI, MCP or API and build verified lists in Claude, GPT or Hermes.
Cactal is the website platform for AI agents. Connect Claude Code, Cursor, or anything that speaks MCP, and your agent gets the tools to design, build, host, and operate production websites: source code, CMS, assets, domains, analytics, and publishing.
Chinese writing toolbox for Claude Code: text analysis, outline generation, GB/T 7714 references,character frequency
A local MCP server that gives Claude Code, Cursor and Codex read access to your DynamoDB schema and items, with every write staged for human review.
Enables persistent knowledge storage for Claude using a knowledge graph with multiple database backends like PostgreSQL and SQLite.
Enables persistent memory for Claude using a knowledge graph stored in local JSON files.
Biologically-inspired memory for Claude. Hebbian plasticity, dream cycles, and temporal decay for persistent knowledge synthesis.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
