MCP.so
Sign In
R

Run Sql Connectorx

@gigamori

Repository

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

Category

Databases

Transports

stdio

Publisher

gigamori

Submitted by

Takamichi Yanai

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

Snowflake MCP Server

isaacwasserman

185

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K