I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

Postgres_mcp_server
Serveur MCP basé sur FastMCP pour contrôler les Postgres
1
Github Watches
0
Github Forks
0
Github Stars
PostgreSQL MCP Server (Model Context Protocol)
A basic implementation of FastMCP for PostgreSQL, enabling direct interaction with PostgreSQL databases from Claude AI.
With this MCP, you can transform your AI chat experience by:
- Storing and retrieving chat data in PostgreSQL databases
- Creating AI applications with persistent data storage
- Building knowledge management systems with structured database queries
- Analyzing large datasets directly through natural language prompts
- Implementing database-driven workflows without writing traditional code
This implementation leverages the MCP protocol to securely bridge Claude AI with PostgreSQL databases, allowing Claude to execute operations on your behalf while maintaining proper isolation and security boundaries.
Features
- Query execution against PostgreSQL databases
- Table management (create, drop)
- Data operations (select, insert, update, delete)
- Schema inspection
- Integrated with Claude through MCP protocol
Prerequisites
- Python 3.8+
- PostgreSQL server
- Access to Claude AI with MCP capabilities
Installation
-
Clone this repository to your local machine
-
Create and activate a Python virtual environment:
# Create virtual environment
python -m venv .mcp
# Activate virtual environment
# On macOS/Linux
source .mcp/bin/activate
# On Windows
.mcp\Scripts\activate
- Install required dependencies:
pip install -r requirements.txt
Configuration
-
Create a
.env
file in the project root with your PostgreSQL connection details and debugging: -
Configure the PostgreSQL MCP with Claude AI app by adding the following configuration:
{
"mcpServers": {
"PostgreSQL MCP": {
"command": "<path/to/clonedrepo/.mcp/bin/uv",
"args": [
"run",
"--with",
"mcp[cli]",
"--with",
"asyncpg",
"--with",
"httpx",
"--with",
"python-dotenv",
"--with",
"psycopg2-binary",
"mcp",
"run",
"path/to/clonedrepo/postgres_mcp_server.py"
],
"env": {
"POSTGRES_HOST": "<your_postgres_host>",
"POSTGRES_PORT": "<your_postgres_port>",
"POSTGRES_USER": "<your_username>",
"POSTGRES_PASSWORD": "<your_password>",
"POSTGRES_DB": "<your_database_name>"
}
}
}
}
Note : Replace "path/to/clonedrepo/" with actual path
Add this configuration to the Claude AI app settings in the MCP configuration section. This will allow Claude to connect to your PostgreSQL MCP server.
相关推荐
I find academic articles and books for research and literature reviews.
Confidential guide on numerology and astrology, based of GG33 Public information
Advanced software engineer GPT that excels through nailing the basics.
Take an adjectivised noun, and create images making it progressively more adjective!
Découvrez la collection la plus complète et la plus à jour de serveurs MCP sur le marché. Ce référentiel sert de centre centralisé, offrant un vaste catalogue de serveurs MCP open-source et propriétaires, avec des fonctionnalités, des liens de documentation et des contributeurs.
Manipulation basée sur Micropython I2C de l'exposition GPIO de la série MCP, dérivée d'Adafruit_MCP230XX
L'application tout-en-un desktop et Docker AI avec chiffon intégré, agents AI, constructeur d'agent sans code, compatibilité MCP, etc.
Miroir dehttps: //github.com/bitrefill/bitrefill-mcp-server
Un puissant plugin Neovim pour gérer les serveurs MCP (Protocole de contexte modèle)
Reviews

user_RiwluKer
As a loyal MCP user, I must say that the Netlify MCP Server by MCERQUA is an outstanding addition to my toolkit. It's straightforward to integrate and offers exceptional performance for my web projects. If you're looking to optimize your workflow and need a reliable server solution, I highly recommend this product. Check it out at https://mcp.so/server/netlify-mcp/MCERQUA!