MCP Postgres Server
A server implementing the Model Context Protocol (MCP) for Cursor that allows using a PostgreSQL database as storage for model contexts, enabling secure database exploration and querying.
MadeByNando
README
MCP Postgres Server
Ce serveur implémente le protocole MCP (Model Context Protocol) pour Cursor, permettant d'utiliser une base de données PostgreSQL comme stockage pour les contextes de modèle.
Prérequis
- Docker
- Docker Compose
Installation et démarrage
- Clonez ce dépôt
- Démarrez le serveur avec Docker Compose:
docker-compose up -d
Configuration dans Cursor
- Ouvrez Cursor
- Allez dans Paramètres > MCP
- Ajoutez une nouvelle connexion avec les paramètres suivants:
- Nom: MCP Postgres Server
- Type: command
- Commande:
docker exec -i mcp-postgres-server node dist/index.js
Résolution des problèmes
Si le serveur ne démarre pas correctement:
-
Vérifiez les logs du conteneur:
docker logs mcp-postgres-server -
Pour redémarrer le serveur:
docker-compose restart
Fonctionnalités du serveur MCP
Le serveur MCP PostgreSQL expose les outils suivants pour Cursor:
postgres_query- Exécuter une requête SQL en lecture seulepostgres_list_tables- Lister toutes les tables de la base de donnéespostgres_describe_table- Obtenir le schéma d'une table spécifique
Ces outils permettent à Cursor d'explorer et d'interroger la base de données de manière sécurisée.
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
Excel MCP Server
A Model Context Protocol server that enables AI assistants to read from and write to Microsoft Excel files, supporting formats like xlsx, xlsm, xltx, and xltm.
Playwright MCP Server
Provides a server utilizing Model Context Protocol to enable human-like browser automation with Playwright, allowing control over browser actions such as navigation, element interaction, and scrolling.
MCP Package Docs Server
Facilitates LLMs to efficiently access and fetch structured documentation for packages in Go, Python, and NPM, enhancing software development with multi-language support and performance optimization.
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
@kazuph/mcp-taskmanager
Model Context Protocol server for Task Management. This allows Claude Desktop (or any MCP client) to manage and execute tasks in a queue-based system.
Apple MCP Server
Enables interaction with Apple apps like Messages, Notes, and Contacts through the MCP protocol to send messages, search, and open app content using natural language.
Linear MCP Server
Enables interaction with Linear's API for managing issues, teams, and projects programmatically through the Model Context Protocol.