PostgreSQL
Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.
K_YH mcp-db-server
Introduction
This package is purely experimental and just for fun!
Do not use this code in production or with any critical databases.
This implementation grants full control over the database to the agent. Therefore, it is strongly discouraged to use shared or sensitive databases.
References
This implementation is based on the mcp/postgres Docker image.
Usage
npx @k_yh/mcp-db-server <your-postgresql-url>
For example:
npx @k_yh/mcp-db-server 'postgresql://user:[email protected]:5432/my-db'
To use this with an agent like Claude desktop or Cursor, configure it like so:
{
"mcpServers": {
"my-db-server": {
"command": "npx",
"args": [
"-y",
"@k_yh/mcp-db-server",
"postgresql://user:password@localhost:5432/my-db"
]
}
}
}
You can manipulate the database through the agent using your prompt.
Related Servers
SingleStore MCP Server
An MCP server for interacting with SingleStore databases, requiring environment variables for connection.
Pinecone
Read and write to a Pinecone vector database using the Model Context Protocol.
Teradata MCP Server
Interact with Teradata databases for data queries and business intelligence.
Postgres MCP Pro
An MCP server for PostgreSQL providing index tuning, explain plans, health checks, and safe SQL execution.
FDA Data MCP
FDA-only compliance data MCP (recalls, warning letters, inspections, 483s, approvals, CFR parts).
Baserow
Read and write access to your Baserow tables.
Couchbase
Interact with the data stored in Couchbase clusters using natural language.
MCP Alchemy
Explore, query, and analyze SQLAlchemy-compatible databases directly from your desktop.
Bankless Onchain
Interact with blockchain data using the Bankless API.
Trino MCP Server
Securely interact with Trino databases to list tables, read data, and execute SQL queries.