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 database gateway that exposes SQL data sources via a RESTful API and the Model Context Protocol (MCP), enabling structured interaction with multiple database types.
mysql-mcp-server
Acts as a read-only MySQL server proxy that exposes database introspection and query execution tools to AI clients via the Model Context Protocol (MCP) or a REST API.
mcp-server
A Model Context Protocol (MCP) server that provides real-time Indian options market data and volatility analytics from GetOutpost.in for integration with AI chat models like Claude.
mcp-sql-server
A secure Model Context Protocol (MCP) server for Microsoft SQL Server, providing safe, read-only database access with comprehensive protection layers, SQL script review, schema discovery, and execution plan analysis.