gigamori/mcp-run-sql-connectorx

Overview

An MCP server that executes SQL queries via ConnectorX and streams results as Arrow RecordBatch. Outputs data to CSV or Parquet. Supports PostgreSQL, MySQL, MariaDB, SQLite, MS SQL Server, Amazon Redshift, and Google BigQuery.

Best for

Best for
Developers who need to run SQL queries and export results via the MCP protocol

Use cases

• Run SQL queries from an MCP client and export results to CSV or Parquet
• Stream query results efficiently using Arrow RecordBatch for large datasets
• Connect to multiple database types through a single MCP server interface

Notes

An MCP server that executes SQL queries via ConnectorX and streams results as Arrow RecordBatch. Outputs data to CSV or Parquet. Supports PostgreSQL, MySQL, MariaDB, SQLite, MS SQL Server, Amazon Redshift, and Google BigQuery.

1 stars on GitHub. Last updated 2025-09-03. Licensed MIT.

Use cases

• Run SQL queries from an MCP client and export results to CSV or Parquet
• Stream query results efficiently using Arrow RecordBatch for large datasets
• Connect to multiple database types through a single MCP server interface

Pros

• Supports a wide range of databases including cloud and on-premise
• Uses Arrow for efficient data streaming and format conversion
• Simple integration with MCP-compatible clients

Cons

• Low community adoption (1 star) indicates limited testing or documentation
• No built-in authentication or security features mentioned
• Requires an MCP client to interact; not a standalone query tool

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.