R

Rathoddarshil MCP Postgres Query Server

A PostgreSQL query server implementing the MCP protocol, providing read-only database query services for clients such as Claude Desktop, including functions such as SQL validation and timeout protection.
2 points
16

What is the MCP Postgres Query Server?

This is a database query tool specifically designed for Claude Desktop. It allows users to securely query PostgreSQL databases without modifying any data. Through the Model Context Protocol (MCP), you can directly run SQL queries in Claude Desktop and obtain results.

How to use the MCP Postgres Query Server?

You need to configure the connection settings of Claude Desktop first, and then you can directly enter SQL query commands in the interface. The server will automatically verify the security of the query to ensure that only read operations are performed.

Use cases

Suitable for users who need to obtain information from a PostgreSQL database but do not have direct database access rights, or for scenarios where database queries need to be integrated into an AI workflow.

Main features

Read-only database accessEnsure database security by only allowing SELECT queries and preventing accidental modification or deletion of data
Query validationAutomatically check SQL statements to ensure that only secure read operations are performed
Timeout protectionAutomatically terminate queries that run for more than 10 seconds to prevent resource occupation
Structured responseQuery results are returned in a clear and readable JSON format

Advantages and limitations

Advantages
Provide a secure way to access the database without worrying about data modification
Seamlessly integrate with Claude Desktop to improve work efficiency
Automatically verify query security to reduce risks
Fast response and easy-to-process result format
Limitations
Only support PostgreSQL databases
Only perform read operations and do not support data modification
Query complexity is limited by the 10-second timeout setting
Require pre-configured database connection information

How to use

Install the server
Clone the repository and install dependencies
Configure Claude Desktop
Edit the Claude Desktop configuration file and add MCP server connection information
Restart Claude Desktop
Restart Claude Desktop after saving the configuration to make the changes take effect
Start querying
Use the query-postgres tool in the Claude Desktop interface to execute SQL queries

Usage examples

Product data analysisQuery the list of products with a price higher than 100 yuan
User statisticsCount the number of newly registered users in the last month
Sales reportGenerate a sales total report grouped by category

Frequently asked questions

Why was my query rejected?
What happens if a query runs for more than 10 seconds?
How can I view the tables in the database?
Do you support other databases such as MySQL or SQLite?
How do I update the server configuration?

Related resources

GitHub repository
Project source code and latest updates
PostgreSQL official documentation
Complete documentation for the PostgreSQL database
MCP protocol description
Detailed description of the Model Context Protocol
Claude Desktop user guide
Official user documentation for Claude Desktop
Installation
Copy the following command to your Client for configuration
{
    "mcpServers": {
        "postgres-query": {
            "command": "node",
            "args": [
                "/path/to/your/mcp-postgres-query-server/dist/index.js",
                "postgresql://username:password@hostname:port/database"
            ]
        }
    }
}

{
    "mcpServers": {
        "postgres-query": {
            "command": "node",
            "args": [
                "/Users/darshilrathod/mcp-servers/mcp-postgres-query-server/dist/index.js",
                "postgresql://user:password@localhost:5432/mydatabase"
            ]
        }
    }
}
Note: Your key is sensitive information, do not share it with anyone.
S
Search1api
The Search1API MCP Server is a server based on the Model Context Protocol (MCP), providing search and crawling functions, and supporting multiple search services and tools.
TypeScript
336
4 points
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
823
4.3 points
M
MCP Alchemy
Certified
MCP Alchemy is a tool that connects Claude Desktop to multiple databases, supporting SQL queries, database structure analysis, and data report generation.
Python
317
4.2 points
P
Postgresql MCP
A PostgreSQL database MCP service based on the FastMCP library, providing CRUD operations, schema inspection, and custom SQL query functions for specified tables.
Python
105
4 points
M
MCP Scan
MCP-Scan is a security scanning tool for MCP servers, used to detect common security vulnerabilities such as prompt injection, tool poisoning, and cross-domain escalation.
Python
609
5 points
A
Agentic Radar
Agentic Radar is a security scanning tool for analyzing and assessing agentic systems, helping developers, researchers, and security experts understand the workflows of agentic systems and identify potential vulnerabilities.
Python
548
5 points
C
Cloudflare
Changesets is a build tool for managing versions and releases in multi - package or single - package repositories.
TypeScript
1.5K
5 points
E
Edgeone Pages MCP Server
EdgeOne Pages MCP is a service that quickly deploys HTML content to EdgeOne Pages via the MCP protocol and obtains a public URL
TypeScript
250
4.8 points
Featured MCP Services
M
Markdownify MCP
Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.
TypeScript
1.7K
5 points
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
823
4.3 points
G
Gitlab MCP Server
Certified
The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.
TypeScript
79
4.3 points
N
Notion Api MCP
Certified
A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.
Python
130
4.5 points
U
Unity
Certified
UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.
C#
554
5 points
F
Figma Context MCP
Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.
TypeScript
6.6K
4.5 points
C
Context7
Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.
TypeScript
5.2K
4.7 points
M
Minimax MCP Server
The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.
Python
745
4.8 points
AIbase
Zhiqi Future, Your AI Solution Think Tank
© 2025AIbase