Postgresql Mcp
What is Postgresql Mcp
PostgreSQL-MCP is a PostgreSQL database interface service based on the MCP framework, providing easy-to-use tools for PostgreSQL database operations.
Use cases
Use cases include backend services for web applications, data processing tasks, and any scenario requiring interaction with PostgreSQL databases.
How to use
To use PostgreSQL-MCP, clone the repository, create a virtual environment, and install the dependencies. Configure the database connection using environment variables or command-line parameters, and then start the service using ‘python postgresql-mcp.py’.
Key features
Key features include executing SQL queries, listing all tables in a specified schema, describing table structures, and listing all schemas in the database.
Where to use
PostgreSQL-MCP can be used in various fields such as web development, data analysis, and application development where PostgreSQL databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Postgresql Mcp
PostgreSQL-MCP is a PostgreSQL database interface service based on the MCP framework, providing easy-to-use tools for PostgreSQL database operations.
Use cases
Use cases include backend services for web applications, data processing tasks, and any scenario requiring interaction with PostgreSQL databases.
How to use
To use PostgreSQL-MCP, clone the repository, create a virtual environment, and install the dependencies. Configure the database connection using environment variables or command-line parameters, and then start the service using ‘python postgresql-mcp.py’.
Key features
Key features include executing SQL queries, listing all tables in a specified schema, describing table structures, and listing all schemas in the database.
Where to use
PostgreSQL-MCP can be used in various fields such as web development, data analysis, and application development where PostgreSQL databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
PostgreSQL-MCP
PostgreSQL-MCP 是一个基于 MCP 框架的 PostgreSQL 数据库接口服务，提供了简单易用的 PostgreSQL 数据库操作工具。
安装
- 克隆本仓库
- 创建虚拟环境并安装依赖
cd postgresql-mcp
python -m venv .venv
source .venv/bin/activate # Linux/Mac
# 或
.venv\Scripts\activate # Windows
pip install -e .
使用方法
通过环境变量或命令行参数配置数据库连接：
# 通过环境变量
export POSTGRES_HOST=localhost
export POSTGRES_PORT=5432
export POSTGRES_USER=postgres
export POSTGRES_PASSWORD=postgres
export POSTGRES_DATABASE=postgres
# 启动服务
python postgresql-mcp.py
或使用命令行参数：
python postgresql-mcp.py --host localhost --port 5432 --user postgres --password postgres --database postgres
主要功能
execute_query: 执行 SQL 查询list_tables: 列出指定模式中的所有表describe_table: 获取表结构list_schemas: 列出数据库中的所有模式
注意事项
确保 PostgreSQL 服务器已启动且可访问。
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
