PostgreSQL

Created By
vinsidiousa year ago
MCP server for getting schema information from a PostgreSQL database
Overview

what is MCP-PG-Schema?

MCP-PG-Schema is a Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

how to use MCP-PG-Schema?

To use MCP-PG-Schema, configure it with the Claude Desktop app or run it using Docker or NPX with the appropriate PostgreSQL connection string.

key features of MCP-PG-Schema?

  • Execute read-only SQL queries against PostgreSQL databases.
  • Automatically discover and provide JSON schema information for each table, including column names and data types.
  • Supports configuration through Docker and NPX for easy deployment.

use cases of MCP-PG-Schema?

  1. Inspecting database schemas for data analysis.
  2. Executing read-only queries for reporting purposes.
  3. Integrating with LLMs for enhanced data interaction.

FAQ from MCP-PG-Schema?

  • Can MCP-PG-Schema modify data in the database?

No, MCP-PG-Schema only allows read-only access to the database.

  • Is there a specific PostgreSQL version required?

MCP-PG-Schema is compatible with standard PostgreSQL databases, but it's recommended to use the latest version for best performance.

  • How do I configure the server?

You can configure the server using the "mcpServers" section in your claude_desktop_config.json or by using Docker/NPX commands.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
vinsidious
Star
-
Language
-
License
-

Recommend Servers

View All
//beforeyouship — LLM Cost Modeling From Your Editor
@Indiegoing

Query realistic LLM cost models without leaving your editor. beforeyouship models the **true monthly cost** of an LLM app architecture — retries, prompt caching, batch discounts, infra overhead, and 3×/10× growth — across GPT-5.x, Claude, Gemini, DeepSeek, and more. Not a token calculator: a planning tool for the design phase, before you commit to a stack. **No API key needed to try it** — demo mode covers the six free-tier models. A Pro key from [beforeyouship.dev](https://beforeyouship.dev) unlocks the full 18-model catalog. ## What you can ask - "How much will a RAG chatbot cost at 10,000 requests/day?" - "Compare Claude Haiku vs Gemini Flash pricing for my workload" - "What's the cheapest model for a multi-step agent at scale?" - "Show me current per-token prices for Anthropic models" ## Tools ### `estimate_cost` Full cost model for an architecture at a given usage level. Returns Naive / Realistic / Worst Case monthly cost per model, 3×/10× growth scenarios, and an opinionated recommendation with reasoning. ### `get_model_prices` Current per-1M-token pricing — input, output, cached input, batch — with context windows and staleness metadata. ### `list_archetypes` Seven preset architecture patterns (simple chatbot, chatbot with history, RAG pipeline, multi-model router, coding assistant, document processor, multi-step agent) used as starting points for estimates. ## Setup **Claude Code:** ​```bash claude mcp add --transport http beforeyouship https://beforeyouship.dev/api/mcp ​``` **Cursor / other clients** — add a remote server: ​```json { "mcpServers": { "beforeyouship": { "type": "streamable-http", "url": "https://beforeyouship.dev/api/mcp" } } } ​``` Add an `Authorization: Bearer bys_...` header with a Pro key for the full catalog. ## Try it > Estimate the monthly cost of a RAG pipeline at 10,000 requests/day

5 hours ago
Mnemom

6 hours ago