mcp_tutorial

SA01/mcp_tutorial
★ 0 stars Python Database Updated 1mo ago
Building a production-grade MCP server over PostgreSQL. Companion code for the Medium article Building Production-Grade MCP Servers
View on GitHub → 🔍 Audit Wallet Slippage →

Quick Install

Copy the config for your editor. Some servers may need additional setup — check the README.

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "mcp_tutorial": {
      "command": "uvx",
      "args": [
        "mcp-tutorial"
      ]
    }
  }
}

Or install with pip: pip install mcp-tutorial

README Excerpt

Companion repository for the article **[Building Production-Grade MCP Servers](https://medium.com/@suffyan.asad1/building-production-grade-mcp-servers-b762a7436927)**. This repo builds an MCP (Model Context Protocol) server over a PostgreSQL database of NYC Yellow Taxi trips (~48 million rows), and then progressively rebuilds it the way you would for production — moving from a single `run_sql` tool to a layered design with scoped database roles, narrow tools, a validated query builder, resources

Topics

claudefastmcpgenerative-aillmmcpmodel-context-protocolpythonpython3
📊
Working with market or time-series data?
The Polymarket Historical Dataset — 18.5M+ price snapshots across 18,600+ prediction markets (CSV + SQLite). Built for backtesting & ML.
View dataset →