Secure SQL MCP Server

Example Use Cases

• 1

  Safe and validated SQL query execution against multiple database types.

• 2

  Read-only or controlled write access to SQL databases with granular permission enforcement.

• 3

  Explore database schemas and run safe queries via an MCP protocol.

Description

This MCP server provides a secure interface for large language models to query multiple types of SQL databases including SQLite, PostgreSQL, MySQL, and MSSQL. It features safe-by-default SQL validation middleware, read-only mode enforcement, forbidden keyword detection, and granular control over destructive statements. The server supports multi-instance setups, automatic row limiting, and optional table allowlists, making it suitable for safe and controlled database exploration and querying. Authentication is supported via API keys with scoped permissions to ensure secure access.