genealogy-postgres-mcp
Verified Safeby peterdewit
Overview
Provides a structured, persistent PostgreSQL database backend for AI agents performing genealogical research.
Installation
docker-compose up -dEnvironment Variables
- DATABASE_URL
- DB_HOST
- DB_PORT
- DB_NAME
- DB_USER
- DB_PASSWORD
Security Notes
The server explicitly avoids dynamic SQL table names and uses parameterized queries (e.g., `%s`) throughout `server.py`, which effectively prevents SQL injection vulnerabilities. Database connection details are correctly sourced from environment variables, avoiding hardcoded secrets. No `eval` or similar dangerous patterns are present. The design is robust for its stated purpose.
Similar Servers
tiger-docs-mcp-server
An MCP server and Claude plugin providing AI assistants with advanced PostgreSQL knowledge through semantic documentation search and curated best practice skills.
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).
polarbase
Extensible open-source data backend for PostgreSQL with a multi-view UI (spreadsheet), AI agent integration via MCP, and real-time capabilities.