pg-aiguide
Verified Safeby jhonny028966
Overview
An MCP server and Claude plugin designed to enhance AI coding tools by providing specialized PostgreSQL and TimescaleDB documentation, semantic search capabilities, and curated best practice skills.
Installation
bun src/index.ts httpEnvironment Variables
- OPENAI_API_KEY
- PGHOST
- PGPORT
- PGUSER
- PGPASSWORD
- PGDATABASE
- DB_SCHEMA
- ENABLE_KEYWORD_SEARCH
- DISABLE_MCP_SKILLS
- NODE_ENV
Security Notes
The server employs standard security practices such as loading sensitive database credentials and API keys from environment variables, preventing hardcoding. SQL queries are parameterized to mitigate SQL injection risks. There is no usage of 'eval' or other obfuscation techniques. Network interactions are primarily with a PostgreSQL database and OpenAI for embedding generation, which are standard for its functionality. Overall, the codebase appears robust regarding common web application security concerns.
Similar Servers
context-portal
Manages structured project context for AI assistants and developer tools, enabling Retrieval Augmented Generation (RAG) and prompt caching within IDEs.
db-mcp-server
Provides AI assistants with structured access to multiple database systems (MySQL, PostgreSQL, SQLite, TimescaleDB) through the Model Context Protocol (MCP).
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
opensearch-mcp-server-py
Enables AI assistants and LLMs to interact with OpenSearch clusters by providing a standardized Model Context Protocol (MCP) interface through built-in and dynamic tools.