Postgres

Created By
guoling2008a year ago
Overview

what is go-mcp-postgres?

go-mcp-postgres is a Model Context Protocol (MCP) server designed for interacting with Postgres databases, allowing for easy CRUD operations and automation without the need for a Node.js or Python environment.

how to use go-mcp-postgres?

To use go-mcp-postgres, you can either download the latest release and add it to your PATH or build it from source using Go. You can then run the server with command line arguments to connect to your Postgres database.

key features of go-mcp-postgres?

  • Zero burden, ready-to-use MCP server for Postgres.
  • Supports CRUD operations on Postgres databases and tables.
  • Read-only mode to prevent unintended write operations.
  • Ability to check query plans using the EXPLAIN statement before execution.

use cases of go-mcp-postgres?

  1. Automating database interactions without complex setups.
  2. Performing safe read-only operations on production databases.
  3. Quickly creating and managing Postgres tables and data.

FAQ from go-mcp-postgres?

  • Is go-mcp-postgres production-ready?

No, it is still a work in progress and may not be ready for production use.

  • What programming environments are required?

No Node.js or Python environment is needed; it runs independently.

  • Can I use it for read-only operations?

Yes, you can enable a read-only mode to restrict operations.

Server Config

{
  "mcpServers": {
    "postgres": {
      "command": "go-mcp-postgres",
      "args": [
        "--dsn",
        "postgresql://user:pass@host:port/db"
      ]
    }
  }
}
Project Info
Created At
a year ago
Updated At
a year ago
Author Name
guoling2008
Star
-
Language
-
License
-
Category
databases

Recommend Servers

View All
Shippo
@Shippo

16 hours ago
Linkpulse

11 hours ago
Puter Mcp

a day ago
//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

8 hours ago