PostgreSQL

by guoling2008

4 stars

Not rated

GitHub

About

Enables secure interaction with PostgreSQL databases for schema management and CRUD operations with safety features like read-only mode and query plan validation

Details

Author: guoling2008
Repository: guoling2008/go-mcp-postgres
GitHub stars: 4
License: MIT License
Categories: Database, Other, Productivity, Design, Developer Tools, Search, Frontend, Infrastructure, Project Management

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name PostgreSQL

Command (node, npx, python, etc.) npx
Arguments
- Argument 1 -y
- Argument 2 @highlight/mcp-server
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "/c",
                "npx",
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "/c",
                "npx",
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "/c",
                "npx",
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "/c",
                "npx",
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "/c",
                "npx",
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

`list_database`

Returns a list of matching database names. Parameters: None

`list_table`

Returns a list of matching table names. Parameters: name (optional string) - If provided, list tables with the specified name, otherwise, list all tables.

`create_table`

Creates a new table in the database. Parameters: query (string) - The SQL query to create the table. Returns: x rows affected.

`alter_table`

Alters an existing table in the Postgres server. Parameters: query (string) - The SQL query to alter the table. Returns: x rows affected.

`desc_table`

Describes the structure of a table. Parameters: name (string) - The name of the table to describe. Returns: The structure of the table.

`read_query`

Executes a read-only SQL query. Parameters: query (string) - The SQL query to execute. Returns: The result of the query.

`write_query`

Executes a write SQL query. Parameters: query (string) - The SQL query to execute. Returns: x rows affected, last insert id: <last_insert_id>.

`update_query`

Executes an update SQL query. Parameters: query (string) - The SQL query to execute. Returns: x rows affected.

`delete_query`

Executes a delete SQL query. Parameters: query (string) - The SQL query to execute. Returns: x rows affected.

`count_query`

Queries the number of rows in a certain table. Parameters: name (string) - The name of the table to count. Returns: The row number of the table.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "postgresql": {
            "env": {},
            "args": [
                "-y",
                "@highlight/mcp-server"
            ],
            "command": "npx"
        }
    }
}

Linux

{
    "env": [],
    "args": [
        "-y",
        "@highlight/mcp-server"
    ],
    "command": "npx"
}

Macos

{
    "env": [],
    "args": [
        "-y",
        "@highlight/mcp-server"
    ],
    "command": "npx"
}

Windows

{
    "env": [],
    "args": [
        "/c",
        "npx",
        "-y",
        "@highlight/mcp-server"
    ],
    "command": "cmd"
}

Copy code fromhttps://github.com/Zhwt/go-mcp-mysql/and with AI help, I change db from mysql to postgres. Zero burden, ready-to-use Model Context Protocol (MCP) server for interacting with Postgres and automation. No Node.js or Python environment needed. This server provides tools to do CRUD operations on MySQL databases and tables, and a read-only mode to prevent surprise write operations. You can also make the MCP server check the query plan by using aEXPLAINstatement before executing the query by adding a--with-explain-checkflag.

Please note that this is a work in progress and may not yet be ready for production use.
-

Get the latest releaseand put it in your$PATHor somewhere you can easily access.

Or if you have Go installed, you can build it from source:

go install -v github.com/guoling2008/go-mcp-postgres@latest

Method A: Using Command Line Arguments for stdio mode

{ "mcpServers": { "postgres": { "command": "go-mcp-postgres", "args": [ "--dsn", "postgresql://user:pass@host:port/db" ] } } }

Note: For those who put the binary outside of your$PATH, you need to replacego-mcp-postgreswith the full path to the binary: e.g.: if you put the binary in theDownloadsfolder, you may use the following path:

{ "mcpServers": { "postgres": { "command": "C:\\Users\\<username>\\Downloads\\go-mcp-postgres.exe", "args": [ ... ] } } }

Method B: Using Command Line Arguments for sse mode

./go-mcp-postgres --t sse --ip x.x.x.x --port nnnn --dsn postgresql://user:pass@host:port/db --lang en

- --lang: Set language option (en/zh-CN), defaults to system language
- Add a--read-onlyflag to enable read-only mode. In this mode, only tools beginning withlist,read_anddesc_are available. Make sure to refresh/restart the MCP server after adding this flag.
- By default, CRUD queries will be first executed with aEXPLAIN ?statement to check whether the generated query plan matches the expected pattern. Add a--with-explain-checkflag to disable this behavior.

Multi-language support: All tool descriptions will automatically localize based on lang parameter

If you want to add your own language support, please refer to the locales folder. The new locales/xxx/active-xx.toml file should be created if you want to use it in command line.

- ${mcp.tool.list_database.desc}
- Parameters: None
- Returns: A list of matching database names.

- ${mcp.tool.list_table.desc}
- Parameters:

- name: If provided, list tables with the specified name, Otherwise, list all tables.

- ${mcp.tool.create_table.desc}
- Parameters:

- query: The SQL query to create the table.

- Alter an existing table in the Postgres server. The LLM is informed not to drop an existing table or column.
- Parameters:

- query: The SQL query to alter the table.

- Describe the structure of a table.
- Parameters:

- name: The name of the table to describe.

- Execute a read-only SQL query.
- Parameters:

- query: The SQL query to execute.

- Execute a write SQL query.
- Parameters:

- query: The SQL query to execute.

- Execute an update SQL query.
- Parameters:

- query: The SQL query to execute.

- Execute a delete SQL query.
- Parameters:

- query: The SQL query to execute.

- Query the number of rows in a certain table..
- Parameters:

- name: The name of the table to count.

Big thanks tohttps://github.com/Zhwt/go-mcp-mysql/again.

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

A read-only MCP server for querying AWS PostgreSQL databases.

A read-only MCP server for AlloyDB, enabling LLMs to query live data directly from AlloyDB databases.

A read-only MCP server by CData that enables LLMs to query live data from EnterpriseDB databases.

A server for direct interaction with CockroachDB databases.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.

Expert-level PostgreSQL database analysis MCP server for AI assistants.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

list_database

list_table

create_table

alter_table

desc_table

read_query

write_query

update_query

delete_query

count_query

Claude Desktop / Cursor

Linux

Macos

Windows

Method A: Using Command Line Arguments for stdio mode

Method B: Using Command Line Arguments for sse mode

Install

More like this

Sequential Thinking

Redis

Time

Filesystem

EverArt

Google Drive

`list_database`

`list_table`

`create_table`

`alter_table`

`desc_table`

`read_query`

`write_query`

`update_query`

`delete_query`

`count_query`