Run Sql Connectorx
@gigamori
About Run Sql Connectorx
An MCP server that executes SQL via ConnectorX and streams the result to a CSV or Parquet file. Supports PostgreSQL, MariaDB, BigQuery, RedShift, MS SQL Server, etc.
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"run-sql-connectorx": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/gigamori/mcp-run-sql-connectorx",
"run-sql-connectorx",
"--conn",
"<connection_token>",
"--csv-token-threshold",
"500000"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Run Sql Connectorx?
Run Sql Connectorx is an MCP server that uses ConnectorX to execute SQL queries against supported databases and return results as CSV or Parquet files. It is designed for MCP clients that need to run SQL and exchange data efficiently via files instead of inline payloads.
How to use Run Sql Connectorx?
Install via uvx and invoke with the required --conn <connection_token> option. Optionally set --csv-token-threshold <int> to enable per‑line CSV token counting. The server returns the string "OK" on success or "Error: <message>" on failure.
Key features of Run Sql Connectorx
- Efficient streaming via Arrow RecordBatch chunks
- Token-efficient file-based data exchange for MCP
- Cross-database support through ConnectorX
- Robust I/O: CSV headers, Parquet validation, error cleanup
- Output formats: CSV (UTF‑8) and Parquet (PyArrow defaults)
Use cases of Run Sql Connectorx
- Run SQL queries against PostgreSQL, MySQL, SQLite, or BigQuery
- Export large query results as CSV or Parquet for downstream analysis
More Databases MCP servers
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
Comments