mcp_tutorial

SA01/mcp_tutorial

★ 0 stars Python 🗄️ Database Updated 1d ago

Building a production-grade MCP server over PostgreSQL. Companion code for the Medium article Building Production-Grade MCP Servers

View on GitHub → Try with Claude — $10 free →

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

mcp_tutorial

Quick Install

README Excerpt

Topics

Related Database Servers