PostgreSQL

by kwakyounho

Not rated
GitHub

About

Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.

Details

Author
kwakyounho
Categories
Database, Other

Setup

Install PostgreSQL in your MCP client (Claude Desktop, Cursor, Windsurf, and others).

Repository: https://github.com/kwakyounho/pg_mcp_research

Follow the installation instructions in the repository README, then restart your MCP client.

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 isstrongly discouragedto use shared or sensitive databases.

This implementation is based on themcp/postgresDocker image.

- Docker Image on Docker Hub
-
Source Code on GitHub

npx @k_yh/mcp-db-server <your-postgresql-url>
npx @k_yh/mcp-db-server 'postgresql://user:password@127.0.0.1:5432/my-db'

To use this with an agent likeClaude desktoporCursor, 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.

A read-only MCP server by CData that enables LLMs to query live data from EnterpriseDB databases.

Expert-level PostgreSQL database analysis MCP server for AI assistants.

An MCP server for querying a PostgreSQL database in read-only mode.

Provides read-only access to PostgreSQL databases, enabling schema inspection and query execution.

Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.

Transforms PostgreSQL databases from "I have tables and I don't know what they do" into "I understand the entire database structure, relationships, and best practices"

A read-only MCP server for PostgreSQL, enabling LLMs to query live data from PostgreSQL databases.

Read-only MCP server for PostgreSQL, MySQL, and SQL Server with schema introspection, SQL query execution, EXPLAIN/optimization, anomaly detection, PII scanning, and N+1 query detection.

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Query and analyze data with MotherDuck and local DuckDB

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.