A Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support.
A Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support. This server enables LLMs to inspect database schemas across multiple namespaces and execute read-only queries while maintaining schema isolation.
sql
(string): The SQL query to executeThe server provides schema information for each table across authorized schemas:
postgres://<host>/<db_schema>/<table>/schema
)
The server requires a database URL and accepts a comma-separated list of schemas to expose:
npx -y mcp-server-postgres-multi-schema <database-url> [schemas]
postgresql://localhost/mydb
)## Connect with default public schema
npx -y mcp-server-postgres-multi-schema postgresql://localhost/mydb
## Connect with multiple schemas
npx -y mcp-server-postgres-multi-schema postgresql://localhost/mydb public,analytics,staging
Configure the “mcpServers” section in your claude_desktop_config.json
:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"mcp-server-postgres-multi-schema",
"postgresql://localhost/mydb",
"public,audit"
]
}
}
}
This multi-schema MCP server is licensed under the MIT License. You may use, modify, and distribute the software according to the terms in the LICENSE file.
Obsidian Knowledge-Management MCP (Model Context Protocol) server that enables AI agents and development tools to interact with an Obsidian vault. It provides a comprehensive suite of tools for reading, writing, searching, and managing notes, tags, and frontmatter, acting as a bridge to the Obsidian Local REST API plugin.
An MCP server that provides tools for retrieving and processing documentation through vector search, both locally or hosted. Enabling AI assistants to augment their responses with relevant documentation context.
Execute a secure shell in Claude Desktop using the Model Context Protocol.
Model Context Protocol Server for Accessing twitter