Does this tool provide API documentation?

Yes, detailed API documentation is available in the OpenAPI specification (docs/openapi.yaml).

What can I do with this tool?

You can execute SQL queries, perform INSERT/UPDATE/DELETE operations, create databases, and manage table schemas.

What are the prerequisites for using this server?

You need Python 3.8+, PostgreSQL 10+, and optionally Docker and Docker Compose for containerized deployment.

The recommended deployment method is via Docker, making it easy to set up and run. Manual installation is also possible.

What is the Postgres MCP Server?

It's a server that allows you to interact with PostgreSQL databases using the Model Context Protocol (MCP), simplifying database operations.

Postgres

Name: Postgres
Author: asadudin

0•

Interacts with PostgreSQL databases through the Model Context Protocol (MCP).

Postgres provides a Model Context Protocol (MCP) server implementation specifically tailored for PostgreSQL databases. It offers a simplified interface for executing SQL queries, performing database operations like INSERT, UPDATE, and DELETE, creating new databases, managing table schemas, and debugging PostgreSQL connections. The server is containerized with Docker, enabling straightforward deployment and environment-based configuration.

主な機能

01Creates new PostgreSQL databases.

02Executes SQL queries with parameterized inputs.

03Containerized with Docker for easy deployment.

04Creates or updates table schemas.

050 GitHub stars

06Performs INSERT/UPDATE/DELETE operations on PostgreSQL databases.

ユースケース

01Automating database management tasks within an MCP environment.

02Providing a simple interface to interact with PostgreSQL databases through MCP.

03Running SQL queries and receiving results in JSON format.