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
nlp2sql
Converts natural language queries to optimized SQL for enterprise-scale databases, supporting multiple AI providers and robust schema management.
sqlite-mcp-server
Transforms SQLite into an AI-ready database engine with specialized tools for data analysis, JSON operations, text/vector search, and geospatial processing, integrating with MCP clients.
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.
warp-sql-server-mcp
Enables AI assistants (like Warp Terminal or GitHub Copilot) to interact with Microsoft SQL Server databases using natural language queries, with a focus on enterprise-grade security, performance, and advanced database operations.