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
SurrealDB MCP Server
A standardized interface for AI assistants to interact with a SurrealDB database.
MCP Football Server
Provides football (soccer) data using the API-Football service.
Cryptocurrency Market Data
Provides real-time and historical cryptocurrency market data from major exchanges using the CCXT library.
MCP Vertica
A server for managing and querying Vertica databases, including connection, schema, and security management.
Strapi MCP
An MCP server for Strapi CMS, providing access to content types and entries through the MCP protocol.
Iceberg MCP Server (via Impala)
Provides read-only access to Apache Iceberg tables via Apache Impala, allowing LLMs to inspect schemas and execute queries.
Snowflake MCP Service
An MCP server for interacting with Snowflake databases.
PyAirbyte
An AI-powered server that generates PyAirbyte pipeline code and instructions using OpenAI and connector documentation.
SimpleDB MCP
A secure MCP server for accessing and exploring relational databases like MySQL, PostgreSQL, Salesforce, and AWS Glue.
supOS MCP Server
Provides access to supOS open APIs for querying topic structures, real-time and historical data, and executing SQL queries.