Universal SQL MCP Server

# Universal SQL MCP Server ## Project Overview The Universal SQL MCP Server is a comprehensive Model Context Protocol (MCP) server designed to provide seamless database connectivity across multiple SQL database engines. This project enables AI assistants and other MCP clients to interact with various SQL databases through a unified, secure interface. ## Vision Our goal is to create a single, powerful MCP server that can work with any SQL database, eliminating the need for database-specific implementations while maintaining optimal performance and security for each supported database engine. ## Key Innovations ### Multi-Database Architecture - **Unified Interface**: One set of MCP tools works across all supported databases - **Database-Specific Optimizations**: Tailored queries and features for each database engine - **Intelligent Connection Management**: Automatic driver selection and configuration - **Flexible Configuration**: Environment-based setup supporting various deployment scenarios ### Supported Database Engines - **MySQL** - Industry-standard relational database - **PostgreSQL** - Advanced open-source database with rich features - **SQLite** - Lightweight, file-based database perfect for development and testing - **SQL Server** - Enterprise-grade Microsoft database solution ### Security-First Design - **Controlled Access**: Separate tools for read and write operations - **Query Validation**: Built-in protection against dangerous SQL operations - **Environment-Based Configuration**: Secure credential management - **Transaction Safety**: Proper error handling and rollback mechanisms ## Core Features ### Database Schema Inspection Get comprehensive information about database structure including: - Table definitions with comments and metadata - Column specifications with data types and constraints - Index information (primary keys, unique indexes, regular indexes) - Database statistics and performance metrics ### Safe Query Execution - **Read Operations**: Execute SELECT queries with built-in security restrictions - **Write Operations**: Controlled INSERT and UPDATE operations with proper validation - **Connection Testing**: Verify database connectivity and configuration - **Error Handling**: Detailed error messages with database-specific context ### Developer Experience - **Easy Setup**: Simple environment-based configuration - **Comprehensive Logging**: Detailed logging for monitoring and debugging - **Docker Support**: Ready-to-use Docker configurations for all environments - **Interactive Demo**: Built-in demo with sample data for quick testing ## Use Cases ### AI Assistant Integration Enable AI assistants to: - Query database schemas to understand data structure - Execute safe read queries to retrieve information - Perform controlled write operations when authorized - Test database connectivity and troubleshoot issues ### Development and Testing - **Local Development**: Use SQLite for rapid prototyping - **Integration Testing**: Test against multiple database engines - **Production Deployment**: Scale to enterprise databases like PostgreSQL or SQL Server ### Data Analysis and Reporting - **Schema Discovery**: Automatically understand database structure - **Data Exploration**: Execute complex queries across different database types - **Report Generation**: Extract data for analysis and visualization ## Technical Excellence ### Performance Optimizations - **Connection Pooling**: Efficient connection management for network databases - **Database-Specific Queries**: Optimized metadata queries for each database engine - **Lazy Loading**: Resources loaded only when needed - **Caching**: Intelligent caching of schema information ### Reliability and Monitoring - **Health Checks**: Built-in health monitoring endpoints - **Request Logging**: Comprehensive request/response logging - **Error Recovery**: Graceful handling of database connection issues - **Resource Management**: Proper cleanup and resource management ## Getting Started The Universal SQL MCP Server is designed for immediate productivity: 1. **Quick Demo**: Run `python demo.py` to see the server in action with sample data 2. **Easy Configuration**: Copy `.env.example` to `.env` and configure your database 3. **Instant Deployment**: Use Docker for consistent deployment across environments 4. **Comprehensive Documentation**: Detailed examples for all supported databases ## Project Structure ``` universal-sql-mcp/ ├── main.py # Server entry point ├── database.py # Multi-database connection management ├── tools.py # MCP tools implementation ├── demo.py # Interactive demonstration ├── test_connections.py # Database connectivity testing ├── example_usage.md # Comprehensive usage examples ├── docker-compose.yml # Development environment ├── docker-compose.prod.yml # Production deployment └── README.md # Complete documentation ``` ## Contributing We welcome contributions to expand database support, improve performance, and enhance security features. The modular architecture makes it easy to add new database engines or extend existing functionality. ## License This project is open source and available under the terms specified in the LICENSE file.