{"repo":"NetanelBollag/simple-psql-mcp","free":true,"listed":false,"github":"https://github.com/NetanelBollag/simple-psql-mcp","clone":"git clone https://github.com/NetanelBollag/simple-psql-mcp.git","description":"A beginner-friendly MCP server template featuring a PostgreSQL connector with clean, easy-to-understand code. Perfect for developers new to Model Context Protocol who want to experiment and create their own AI tool connectors with minimal setup.","language":"Python","stars":31,"topics":[],"license":"MIT","category":"mcp-servers","readme_excerpt":"Simple PostgreSQL MCP Server This is a template project for those looking to build their own MCP servers. I designed it to be dead simple to understand and adapt - the code is straightforward with MCP docs attached so you can quickly get up to speed. What is MCP? TL;DR - It's a way to write plugins for AI Model Context Protocol (MCP) is a standard way for LLMs to interact with external tools and data. In a nutshell: - Tools allow the LLM to execute commands (like running a database query) - Resources are data you can attach to conversations (like attaching a file to a prompt) - Prompts are templates that generate consistent LLM instructions Features This PostgreSQL MCP server implements: 1. Tools - execute query - Run SQL queries against your database - test connection - Verify the database connection is working 2. Resources - db://tables - List of all tables in the schema - db://tables/{table name} - Schema information for a specific table - db://schema - Complete schema information for all tables in the database 3. Prompts - Query generation templates - Analytical query builders - Based on the templates in this repo Prerequisites - Python 3.8+ - uv - Modern Python package manager and installer - npx (included with Node.js) - PostgreSQL database you can connect to Quick Setup 1. Create a virtual environment and install dependencies: 2. Run the server with the MCP Inspector: Note: If this is your first time running npx, you'll be prompted to approve the installation. Type 'y'","default_branch":null,"files":null,"tree":[],"storefront":"/r/NetanelBollag","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/NetanelBollag/simple-psql-mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}