pg-aiguide
Verified Safeby timescale
Overview
Provides AI-optimized PostgreSQL expertise through semantic search and curated best-practice skills for coding assistants.
Installation
npm run start:httpEnvironment Variables
- OPENAI_API_KEY
- DB_SCHEMA
- PGHOST
- PGPORT
- PGDATABASE
- PGUSER
- PGPASSWORD
- ENABLE_KEYWORD_SEARCH
- DISABLE_MCP_SKILLS
Security Notes
The server uses parameterized SQL queries (e.g., $1, $2) for user inputs in its APIs, which effectively prevents SQL injection. Database schema names are derived from environment variables, which should be set from trusted sources. The Python ingest scripts utilize 'subprocess.run' for system commands, but inputs to these commands are derived from internal logic (e.g., git tags) or trusted configuration, not directly from runtime user input, mitigating command injection risks.
Similar Servers
agent
The 1MCP agent acts as a proxy for the Model Context Protocol, managing various MCP servers, enabling application configuration consolidation, and providing tools for registry interaction and preset management.
mcp_massive
An AI agent orchestration server, likely interacting with LLMs and managing multi-agent workflows.
2ly
2LY provides an infrastructure layer for AI agent tooling, enabling a private tool registry with embedded runtimes that integrate with various agent frameworks like LangChain, CrewAI, and AutoGPT.
mcp-claude-spotify
Enables Claude Desktop to interact with Spotify for music search, playback control, and playlist management via the Model Context Protocol (MCP).