Skip to main content
Glama
JimmyFu-Coder

PostgreSQL MCP Server

by JimmyFu-Coder
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Local

PostgreSQL MCP Server

这是一个MCP (Model Context Protocol) 服务器，允许GPT-4等AI模型查询本地PostgreSQL数据库。

功能

  • 执行SQL查询

  • 列出数据库中的所有表

  • 获取表的结构信息

Related MCP server: PostgreSQL MCP Server

安装

  1. 克隆或下载项目

  2. 安装依赖：

npm install

配置

  1. 复制环境变量模板：

cp .env.example .env

  1. 编辑 .env 文件，配置你的PostgreSQL连接信息：

DB_HOST=localhost
DB_PORT=5432
DB_NAME=your_database_name
DB_USER=your_username
DB_PASSWORD=your_password

运行

开发模式

npm run dev

生产模式

npm run build
npm start

在Claude Desktop中配置

在Claude Desktop的配置文件中添加以下配置：

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/path/to/your/project/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "your_database_name",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

可用工具

query_database

执行SQL查询

  • query: SQL查询语句

  • params: 可选的查询参数数组

list_tables

列出数据库中的所有表

describe_table

获取指定表的结构信息

  • table_name: 表名

示例

一旦配置完成，你可以在Claude中使用以下命令：

  1. "列出数据库中的所有表"

  2. "描述users表的结构"

  3. "查询所有用户：SELECT * FROM users LIMIT 10"

This server cannot be installed

F
license - not found
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • MCP PostgreSQL Server

    antonorlov
    A
    license
    B
    quality
    F
    maintenance
    Enables AI models to interact with PostgreSQL databases through a standardized interface, supporting operations like queries, table manipulation, and schema inspection.
    Last updated
    6
    839
    16
    MIT

  • PostgreSQL MCP Server

    aeiyannn
    A
    license
    -
    quality
    D
    maintenance
    Enables AI assistants to query and manage local PostgreSQL databases through SQL execution and schema exploration tools. It supports both read-only queries and write operations including table creation and data modification via natural language.
    Last updated
    37
    ISC

  • mcp-postgres

    mgcrea
    A
    license
    -
    quality
    D
    maintenance
    Enables AI agents to query and explore PostgreSQL databases with tools for executing SQL queries, listing tables, and describing table structures.
    Last updated
    MIT

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/JimmyFu-Coder/MCP_DB'

If you have feedback or need assistance with the MCP directory API, please join our Discord server