pg-aiguide
Verified Safeby timescale
Overview
Provides AI-optimized PostgreSQL expertise, including semantic search over documentation and curated best practices, to assist AI coding tools in generating better PostgreSQL code.
Installation
bun dist/index.js stdioEnvironment Variables
- OPENAI_API_KEY
- PGHOST
- PGPORT
- PGUSER
- PGPASSWORD
- PGDATABASE
- DB_SCHEMA
Security Notes
The server uses environment variables for sensitive credentials (API keys, database connection parameters). SQL queries are parameterized, mitigating SQL injection risks. The Python ingest scripts execute shell commands (`git clone`, `make html`, `./configure`) for documentation building; while these carry inherent risks, they are used for trusted internal processes (cloning from PostgreSQL's official GitHub repository) and not exposed to arbitrary user input. The server leverages a boilerplate library (`@tigerdata/mcp-boilerplate`), assuming its security. No direct 'eval' or dangerous dynamic code execution from untrusted input is observed in the provided source code.
Similar Servers
agent
Manages and proxies multiple Model Context Protocol (MCP) servers locally, providing a unified entry point and CLI for installation, configuration, and status monitoring.
mcp_massive
An AI agent orchestration server, likely interacting with LLMs and managing multi-agent workflows.
2ly
Skilder is an infrastructure layer for AI agent tooling, providing a private tool registry and embedded runtimes for integrating with various agent frameworks and custom tools.
mcp-claude-spotify
Enables Claude Desktop to interact with Spotify for music control and discovery.