Dynamic-Smart-MCP
Verified Safeby UAEpro
Overview
An intelligent FastMCP 2 server that converts natural language questions into SQL queries or API requests for any SQL database or OpenAPI-defined API using AI.
Installation
python main.pyEnvironment Variables
- LLM_API_KEY
- DATABASE_URL
- API_SPEC_URL
- API_BEARER_TOKEN
- API_KEY
- LLM_MODEL
- LLM_API_BASE
- LLM_TEMPERATURE
- LLM_MAX_TOKENS
- DATABASE_MAX_ROWS
- SAFETY_READ_ONLY
- SECURITY_HIDE_DATABASE_DETAILS
- SECURITY_EXPOSE_SQL
- SECURITY_EXPOSE_COLUMN_NAMES
- SECURITY_EXPOSE_TABLE_NAMES
- SECURITY_LOG_DETAILED_ERRORS
Security Notes
The system implements robust multi-layered security: read-only by default, a comprehensive keyword blacklist (e.g., DROP, DELETE, INSERT), explicit SELECT-only enforcement for SQL, checks for multiple statements to prevent SQL injection, and a ResponseSanitizer that hides database internals (SQL queries, table/column names, detailed errors) from end-users in production mode. API mode includes an `unsafe_mode` flag for allowing non-GET requests, making it a conscious configuration choice rather than an oversight. Secrets are managed via environment variables.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
nlp2sql
Converting natural language queries to optimized SQL for enterprise databases using multiple AI providers.
sqlite-mcp-server
Provides an MCP interface for an SQLite database, offering a wide range of data management, advanced analytics, JSON processing, text/vector search, and geospatial capabilities.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.