database-ontology-mcp
Verified Safeby ralfbecher
Overview
Provides an ontology-based MCP server for database schema analysis, semantic understanding, and Text-2-SQL convenience with built-in safety features.
Installation
uv run server.pyEnvironment Variables
- MCP_MASTER_PASSWORD
- POSTGRES_HOST
- POSTGRES_PORT
- POSTGRES_DATABASE
- POSTGRES_USERNAME
- POSTGRES_PASSWORD
- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USERNAME
- SNOWFLAKE_PASSWORD
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_DATABASE
- DREMIO_URI
- DREMIO_PAT
- DREMIO_HOST
- DREMIO_PORT
- DREMIO_USERNAME
- DREMIO_PASSWORD
Security Notes
The server implements robust SQL injection prevention using `SQLInjectionValidator` and parameterized queries. Credentials are handled by `SecureCredentialManager` with `cryptography` for encryption, which is strong. However, plaintext database passwords are temporarily stored in memory (`_last_connection_params`) for reconnection purposes, which is a common pattern but could be a minor transient risk if server memory is compromised. `ast.literal_eval` is used in `generate_chart` for parsing data_source if passed as a string, which is generally safe for data but always carries an infinitesimal risk compared to strict JSON parsing. Overall, security measures are comprehensive and well-thought-out.
Similar Servers
powerbi-modeling-mcp
Automate Power BI semantic model development and management using AI agents via the MCP protocol.
codegraph-rust
CodeGraph transforms codebases into semantically searchable knowledge graphs, enabling AI agents to reason deeply about code for complex analysis tasks like dependency tracking, architectural understanding, and context building for new features.
mcp-kql-server
An AI-powered Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer, including natural language to KQL (NL2KQL) conversion, intelligent schema discovery, caching, and data visualization.
nlp2sql
Converts natural language queries to optimized SQL for enterprise-scale databases, supporting multiple AI providers and robust schema management.