MCP Postgres Server

MCP Postgres Server

Mirror of

MCP-Mirror

Databases
Visit Server

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

  1. Clonez ce dépôt
  2. Démarrez le serveur avec Docker Compose:
docker-compose up -d

Configuration dans Cursor

  1. Ouvrez Cursor
  2. Allez dans Paramètres > MCP
  3. 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:

  1. Vérifiez les logs du conteneur:

    docker logs mcp-postgres-server

  2. Pour redémarrer le serveur:

    docker-compose restart

Fonctionnalités du serveur MCP

Le serveur MCP PostgreSQL expose les outils suivants pour Cursor:

  1. postgres_query - Exécuter une requête SQL en lecture seule
  2. postgres_list_tables - Lister toutes les tables de la base de données
  3. postgres_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

Supabase MCP Server

Supabase MCP Server

A Model Context Protocol (MCP) server that provides programmatic access to the Supabase Management API. This server allows AI models and other clients to manage Supabase projects and organizations through a standardized interface.

Featured
JavaScript
MCP DuckDB Knowledge Graph Memory Server

MCP DuckDB Knowledge Graph Memory Server

A memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.

Featured
TypeScript
dbt Semantic Layer MCP Server

dbt Semantic Layer MCP Server

A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.

Featured
TypeScript
Metabase MCP Server

Metabase MCP Server

Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.

Featured
JavaScript
Airtable MCP Server

Airtable MCP Server

A Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.

Featured
JavaScript
mcp-shodan

mcp-shodan

MCP server for querying the Shodan API and Shodan CVEDB. This server provides tools for IP lookups, device searches, DNS lookups, vulnerability queries, CPE lookups, and more.

Featured
JavaScript
Verodat MCP Server

Verodat MCP Server

An MCP server that integrates Verodat's data management capabilities with AI systems like Claude Desktop, enabling users to manage accounts, workspaces, and datasets, as well as perform AI-powered queries on their data.

Official
Local
TypeScript
Tembo MCP Server

Tembo MCP Server

An MCP server that enables Claude to interact with Tembo Cloud platform API, allowing users to manage Tembo Cloud resources through natural language.

Official
TypeScript
MongoDB MCP Server

MongoDB MCP Server

Provides read-only access to MongoDB databases for LLMs to inspect collection schemas and execute aggregation pipelines.

Official
JavaScript
nile-mcp

nile-mcp

MCP server for Nile Database - Manage and query databases, tenants, users, auth using LLMs

Official
TypeScript