Run Sql Connectorx
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"
]
}
}
}