Last updated
March 20, 2026
MCP profile
Capital Hove Read Only Local Postgres Mcp Server
MCP server for read-only PostgreSQL database queries in Claude Desktop
Data & AnalyticsPackageJavaScript/TypeScriptOpen SourceExternal
Visibility
Public
ByRegistry
About This MCP Server
MCP server for read-only PostgreSQL database queries in Claude Desktop This MCP server enables AI assistants like Claude to seamlessly interact with Capital Hove Read Only Local Postgres, providing structured access to its functionality through the Model Context Protocol (MCP).
Key Capabilities:
- Execute database queries and retrieve results
- Manage database schemas and migrations
- Monitor database performance and health
- Handle data import/export operations
Common Use Cases:
- Querying and analyzing data without writing raw SQL
- Automating database maintenance tasks
- Building data-driven applications with AI assistance
- Monitoring and optimizing database performance
How It Works: Capital Hove Read Only Local Postgres integrates with AI coding assistants and chat interfaces through the standardized MCP protocol. Once configured, your AI assistant can directly invoke Capital Hove Read Only Local Postgres's tools, enabling natural language interaction with its features without manual API calls or custom integrations.
Technical Details: Server type: Package · Language: JavaScript/TypeScript
Capabilities
Execute read-only SQL queries through Claude Desktop or Claude CodeDynamic database connections - connect to any PostgreSQL database at runtimeBuilt-in security with query validation (only SELECT statements allowed)Easy integration with Claude Desktop and Claude CodeJSON formatted query resultsEnvironment-based default configuration with runtime override support
Tools & Endpoints1
Example Workflow
Claude will automatically convert your natural language requests into appropriate SQL queries and execute them against your database.
What Problems It Solves
- 1. Restart Claude Desktop/Code after updating the configuration 2. Start chatting with Claude about your database
Why Use Capital Hove Read Only Local Postgres Mcp Server?
- Execute read-only SQL queries through Claude Desktop or Claude Code
- Dynamic database connections - connect to any PostgreSQL database at runtime
- Built-in security with query validation (only SELECT statements allowed)
- Easy integration with Claude Desktop and Claude Code
- JSON formatted query results
- Environment-based default configuration with runtime override support
Specifications
Status
live
Industry
Data & Analytics
Category
General
Server type
Package
Language
JavaScript/TypeScript
License
Open Source
Verified
Yes
Requirements
- Node.js (v16 or higher) - If using mise, update the command path accordingly
- PostgreSQL database server
- Claude Desktop application
Hosting
Hosting Options
- Package
API
Integrate this server into your application. Choose a connection method below.
1
Install
Install command
JavaScript/TypeScript
npm install2
Configure
Configuration
json
{
"mcp": {
"servers": {
"postgres": {
"command": "node",
"args": ["/absolute/path/to/read-only-local-postgres-mcp-server/dist/index.js"],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "5432",
"DB_DATABASE": "your_database_name",
"DB_USERNAME": "your_username",
"DB_PASSWORD": "your_password"
}
}
}
}
}Performance
Usage
Quick Reference
- Name
- Capital Hove Read Only Local Postgres Mcp Server
- Function
- MCP server for read-only PostgreSQL database queries in Claude Desktop
- Available Tools
- This MCP server exposes three tools that Claude can use to interact with PostgreSQL databases.
- Transport
- Package
- Language
- JavaScript/TypeScript
- Install
- npm install
- Source
- External (Registry)
- License
- Open Source
Get started
Ready to integrate this MCP server?
Book a demo to see how this server fits your workflow, or explore the full catalog.