mcp_ohmy_sql-project
Verified Safeby MacHu-GWU
Overview
A Model Context Protocol (MCP) server that connects AI assistants to various SQL databases, providing intelligent query optimization, schema introspection, and secure, token-efficient data interaction.
Installation
uvx --with mcp-ohmy-sql[sqlite,postgres,aws_redshift] mcp-ohmy-sqlEnvironment Variables
- MCP_OHMY_SQL_CONFIG
- AWS_ACCESS_KEY_ID
- AWS_SECRET_ACCESS_KEY
- AWS_SESSION_TOKEN
- AWS_REGION
- AWS_PROFILE
Security Notes
The server uses parameterized queries to prevent SQL injection. It implements configurable table filtering for access control. Sensitive database connection details (e.g., passwords, AWS credentials) are intended to be loaded from an external JSON configuration file via an environment variable (`MCP_OHMY_SQL_CONFIG`), not hardcoded in the application logic itself. Test configuration files contain example credentials, but these are for development environments.
Similar Servers
dbhub
A universal database abstraction layer exposing databases as tools for AI/ML agents via the Model Context Protocol (MCP), and providing an admin console for monitoring requests.
mcp-server
Provides real-time Indian options market data and volatility analytics from GetOutpost.in to AI chat platforms like Claude for quantitative analysis and trading insights.
mcp-sql-server
Provides AI assistants with safe, read-optimized access to SQL Server databases.
method-crm-mcp
Enables LLMs to interact with Method CRM data for comprehensive management of tables, files, user information, event-driven automations, and API keys.