Run Sql Connectorx

Created By

gigamori3 months ago

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

Overview Content Tools Comments

Overview

what is Run Sql ConnectorX?

Run Sql ConnectorX is an MCP server that executes SQL queries via ConnectorX and streams the results to CSV or Parquet files, supporting various databases like PostgreSQL, MariaDB, BigQuery, and more.

how to use Run Sql ConnectorX?

To use Run Sql ConnectorX, run the command uvx run-sql-connectorx --conn <connection_token> --csv-token-threshold 500000 in your terminal, replacing <connection_token> with your specific database connection token.

key features of Run Sql ConnectorX?

Efficient streaming of large results in Arrow RecordBatch chunks.
Cross-database compatibility through ConnectorX.
Robust I/O with CSV header handling and Parquet schema validation.
Optional token counting for CSV outputs.

use cases of Run Sql ConnectorX?

Executing SQL queries across multiple database systems.
Streaming large datasets efficiently to CSV or Parquet formats.
Integrating with data processing pipelines that require SQL execution.

FAQ from Run Sql ConnectorX?

What databases does ConnectorX support?

ConnectorX supports various databases including PostgreSQL, MySQL, SQLite, Microsoft SQL Server, Amazon Redshift, and Google BigQuery.

Is there a limit on the size of data that can be streamed?

The tool is designed to handle large datasets efficiently, but performance may vary based on system resources and network conditions.

How do I get the connection token?

The connection token format varies by database; refer to the official ConnectorX documentation for details.

Server Config

{
  "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"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

DeepChatYour AI Partner on Desktop

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

WindsurfThe new purpose-built IDE to harness magic

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

Amap Maps高德地图官方 MCP Server

CursorThe AI Code Editor