solid5-geo-mcp
Verified Safeby GustaafS
Overview
A geo-spatial chatbot and Model Context Protocol (MCP) server for querying Microsoft Fabric SQL databases.
Installation
uv run python -m src.solid5_geo_mcp.serverEnvironment Variables
- FABRIC_SERVER
- FABRIC_DATABASE
- ANTHROPIC_API_KEY
- JWT_SECRET_KEY
- AZURE_TENANT_ID
- AZURE_CLIENT_ID
- AZURE_CLIENT_SECRET
- AZURE_AD_CLIENT_ID
- AZURE_AD_CLIENT_SECRET
- AZURE_AD_TENANT_ID
- REDIRECT_URI
- AUTH_ENABLED
- DEV_MODE
- CONFIG_FILE
- FABRIC_ACCESS_TOKEN
- AZURE_AD_AUTHORITY
- JWT_ALGORITHM
- JWT_EXPIRATION_MINUTES
- DEFAULT_USER_ROLE
- APP_URL
Security Notes
The `simple_query` tool allows execution of arbitrary SQL SELECT statements, which, despite strong safeguards (blocklisting dangerous keywords and restricting to SELECT), always carries a residual risk of injection if bypasses are discovered. All other database interactions use parameterized queries, which is a good practice. Secrets (API keys, JWT secret, Azure credentials) are externalized to environment variables. Authentication and Role-Based Access Control (RBAC) are implemented.
Similar Servers
gis-mcp
A Model Context Protocol (MCP) server that provides AI agents and LLMs with comprehensive GIS capabilities, enabling geospatial analysis, data gathering, and transformations through natural language.
claude-faf-mcp
Optimizes AI understanding of software projects by providing persistent context, fixing context-drift, and enabling bi-directional synchronization between project metadata and AI documentation.
converse
Orchestrates and exposes various AI tools (chat, multi-model consensus, job management) over the Model Context Protocol, enabling local, persistent, and potentially asynchronous AI interactions across multiple Large Language Model (LLM) providers.
sql-server-mcp-server
Provides AI assistants like Claude with secure, structured access to SQL Server databases through natural language queries using the Model Context Protocol.