database-ontology-mcp
by ralfbecher
Overview
Analyzes relational database schemas, generates semantic ontologies (RDF/OWL, R2RML), and provides tools for Text-to-SQL convenience, secure query execution, and data visualization.
Installation
uv run server.pyEnvironment Variables
- LOG_LEVEL
- ONTOLOGY_BASE_URI
- R2RML_BASE_IRI
- OUTPUT_DIR
- MCP_TRANSPORT
- MCP_SERVER_HOST
- MCP_SERVER_PORT
- MCP_MASTER_PASSWORD
- POSTGRES_HOST
- POSTGRES_PORT
- POSTGRES_DATABASE
- POSTGRES_USERNAME
- POSTGRES_PASSWORD
- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USERNAME
- SNOWFLAKE_PASSWORD
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_DATABASE
- SNOWFLAKE_SCHEMA
- SNOWFLAKE_ROLE
- DREMIO_URI
- DREMIO_PAT
- DREMIO_PROJECT_ID
- DREMIO_HOST
- DREMIO_PORT
- DREMIO_USERNAME
- DREMIO_PASSWORD
- DREMIO_SSL
Security Notes
Positive: Implements robust SQL injection and identifier validation, explicitly blocking DML/DDL operations. Utilizes SecureCredentialManager with Fernet encryption and secure salt management. Critical Risk: The DatabaseManager stores database connection passwords in plaintext within `self._last_connection_params` for reconnection purposes. Although a SecureCredentialManager is initialized, its encryption capabilities are not used to protect these stored credentials. This exposes sensitive information in memory, posing a significant risk if the server process memory is accessed or dumped.
Similar Servers
codegraph-rust
Transforms codebases into a semantically searchable knowledge graph, enabling AI agents to reason about code relationships, architecture, and impact rather than just performing text-based searches.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
mcp-kql-server
An AI-powered MCP server that facilitates KQL query execution against Azure Data Explorer through natural language conversion, intelligent schema discovery, and RAG-enhanced context.
SchemaCrawler-AI
Provides an AI-powered interface for natural language database schema exploration, analysis, visualization, and SQL assistance.