supermcp
by dhanababum
Overview
A multi-tenant SQL database connector for the MCP platform, enabling AI assistants to interact with various SQL databases like PostgreSQL, MySQL, MSSQL, Oracle, Snowflake, and SQLite through a unified interface.
Installation
cd connectors/tenants_sqldb && uv run uvicorn main:app --host 0.0.0.0 --port 8026 --workers 4Environment Variables
- CONNECTOR_ID
- CONNECTOR_SECRET
- APP_BASE_URL
- ORIGIN_URLS
- WORKERS
- PORT
Security Notes
The `app/src/users.py` file, which is part of the core SuperMCP backend that manages connectors, contains a hardcoded `SECRET = "SECRET"` used for password reset and email verification tokens. This is a critical vulnerability that makes user account management insecure. Docker Compose files for development (`docker-compose.dev.yml`, `docker-connectors-compose.yml`) include default placeholder secrets (`mysecretpassword`, `your-super-secret-jwt-key-change-in-production`, `CONNECTOR_SECRET` UUIDs) which must be replaced with strong, unique values in production environments. Good security practices observed include the use of parameterized queries to prevent SQL injection, Pydantic for input validation, bcrypt for hashing connector secrets, and FastAPI-Users for authentication.
Similar Servers
metorial-platform
An open source integration platform for agentic AI, connecting AI models to external APIs, data sources, and tools.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
SageMCP
A scalable platform for hosting MCP servers with multi-tenant support, OAuth integration, and connector plugins for various services, deployed on Kubernetes.
nlp2sql
Converting natural language queries to optimized SQL for enterprise databases using multiple AI providers.