Uses .env files for configuration management and storing API keys and database connection information
Utilizes OpenAI's API for Text2SQL conversion, enabling natural language queries to be transformed into SQL
Enables connection to Snowflake data warehouses for executing SQL queries generated from natural language
Connects to SQLite databases to execute generated SQL queries and retrieve data
MCP AI SOC Sher
A powerful AI-driven Security Operations Center (SOC) Text2SQL framework based MCP Server (Local and Remote) for converting natural language Prompts to SQL queries dynamically, with integrated security threat analysis and monitoring.
Features
- Text2SQL Conversion: Convert natural language queries to optimized SQL
- Multiple Interfaces: Support for STDIO, SSE, and REST API
- Security Threat Analysis: Built-in SQL query security analysis
- Multiple Database Support: Connect to SQLite or Snowflake databases
- Streaming Responses: Real-time query processing feedback
- SOC Monitoring: Security Operations Center monitoring capabilities
Installation
Quick Start
Command Line Usage
Configuration
Create a .env
file with your configuration:
See the documentation for all configuration options.
Example
Security Features
- Rule-based and AI-powered SQL query security analysis
- Detection of potential SQL injection attacks
- Sensitive table access monitoring
- Configurable security levels and actions
License
MIT License with Additional Conditions. Copyright (c) 2025 Akram Sheriff.
See LICENSE for details.
Contributing
Contributions are welcome! Please see CONTRIBUTING.md for guidelines.
Related MCP Servers
- Python
- Python
- AsecurityAlicenseAqualityAlchemy MCP ServerLast updated -94,82055TypeScriptMIT License