mcp-server
Verified Safeby exasol
Overview
Provides an LLM access to the Exasol database via MCP tools, enabling metadata browsing, SQL query execution, and BucketFS file system interaction.
Installation
exasol-mcp-serverEnvironment Variables
- EXA_DSN
- EXA_USER
- EXA_PASSWORD
- EXA_ACCESS_TOKEN
- EXA_SAAS_ACCOUNT_ID
- EXA_SAAS_PAT
- EXA_BUCKETFS_URL
- EXA_BUCKETFS_USER
- EXA_BUCKETFS_PASSWORD
- FASTMCP_SERVER_AUTH
- EXA_MCP_LOG_LEVEL
Security Notes
The project demonstrates strong security awareness. It explicitly handles secrets via environment variables, with sensitive data masked in logs. SQL queries are rigorously validated using `sqlglot` to prevent injection, with DML/DDL operations requiring user elicitation and confirmation. Identifiers are properly quoted to prevent injection. The HTTP server explicitly checks for authentication by default, mitigating unauthorized access. File system operations on BucketFS also use elicitation and path validation.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
azure-cosmos-mcp-server-samples
Enables AI assistants (LLMs like Claude, Continue.dev) to interact with and query Azure Cosmos DB databases using natural language.
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.
websets-mcp-server
Manages web entity collections (companies, people, papers) through automated search, data enrichment, and scheduled monitoring using Exa's Websets API.