aligneurs-mcp-server
by Akilinoxx
Overview
This server uses the Model Context Protocol (MCP) to allow AI agents to query and analyze a PostgreSQL database containing aligner activity data.
Installation
docker compose upEnvironment Variables
- DATABASE_URL
- DATABASE_PUBLIC_URL
- DATABASE_HOST
- DATABASE_PORT
- DATABASE_NAME
- DATABASE_USER_NAME
- DATABASE_PASSWORD
- PORT
Security Notes
CRITICAL: The source code (`import_csv_to_postgres.py`, `import_csv_optimized.py`, `create_schema.py`, `setup_railway.sh`) contains hardcoded PostgreSQL database credentials (username, password, host, port, dbname) which are publicly visible. This is a severe security vulnerability. Additionally, the `query_sql` tool allows direct execution of arbitrary SQL SELECT/WITH queries. While a feature for agents, this poses a significant SQL injection risk if the input is not strictly controlled and sanitized, potentially leading to data exfiltration or other database manipulations depending on user permissions.
Similar Servers
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
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).
mcp-postgres
Provides a read-only Model Context Protocol (MCP) server for AI tools (like Claude Code, Cursor) to query a PostgreSQL database directly.