Run Sql Connectorx

Name: Run Sql Connectorx
Author: gigamori

@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.

#sql #connectorx #data-streaming

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

Comments

More Databases MCP servers

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412