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:password@127.0.0.1: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
memory-mcp
A simple MCP server that stores and retrieves memories from multiple LLMs.
Fiscal Data MCP Server
Access US Treasury data via the Fiscal Data API to fetch statements, historical data, and generate reports.
OpenAlex Author Disambiguation
Disambiguate authors and resolve institutions using the OpenAlex.org API.
Supabase Read-Only MCP Server
Provides read-only access to a Supabase database.
Neo4j MCP Server
A read-only query service for Neo4j graph databases.
Solana MCP Server
Provides comprehensive access to Solana blockchain data using 21 essential RPC methods.
AWS PostgreSQL MCP Server
A read-only MCP server for querying AWS PostgreSQL databases.
MCP Knowledge Graph
Provides persistent memory for AI models using a local knowledge graph.
Unofficial STRING MCP Server
Access the STRING protein interaction database for network analysis, functional enrichment, and comparative genomics.
MarkLogic MCP Server by CData
A read-only MCP server by CData for querying live MarkLogic data with LLMs. Requires a separate CData JDBC Driver.