DBConvert Streams (Federated SQL) — Claude Code MCP server
Runs read-only federated SQL across PostgreSQL, MySQL, S3 buckets, and local Parquet or CSV files directly from your AI coding assistant.
claude mcp add streams -- npx -y @dbconvert/stream-mcpWhat DBConvert Streams (Federated SQL) does
This MCP server lets AI assistants inspect database schemas and run federated queries across multiple engines at once. You can link PostgreSQL, MySQL, S3 storage, and directories with Parquet or CSV files inside one session. Cross-database joins work without intermediate data dumps.
Write operations are completely blocked. The server strictly filters commands so that only SELECT queries run, preventing the assistant from altering tables or modifying data rows.
While documentation and examples use the MIT license, the underlying DBConvert Streams binary is proprietary software. Running the server via CLI commands requires npx from Node.js, or the slotix/stream-mcp container in Docker.
What it helps with
- Join PostgreSQL and MySQL tables with local Parquet files in one SQL query
- Inspect schemas across multiple production databases without pasting DDL
- Query S3 buckets and local CSV or JSON data without manual import steps
- Audit database contents safely under an enforced read-only execution policy
Example prompts for the agent
- List all active database connections and show the schema for the customers table.
- Join records from
orders.parquetwith the PostgreSQL customer table and return the top 10 rows. - Compare the table structure between the MySQL and PostgreSQL connections.
How to install DBConvert Streams (Federated SQL)
Platform CLI
claude mcp add streams -- npx -y @dbconvert/stream-mcpPlatform CLI
codex mcp add dbconvert-streams-federated-sql -- npx -y @dbconvert/stream-mcpConfig file
{
"mcpServers": {
"dbconvert-streams-federated-sql": {
"command": "npx",
"args": [
"-y",
"@dbconvert/stream-mcp"
]
}
}
}Config file
{
"servers": {
"dbconvert-streams-federated-sql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@dbconvert/stream-mcp"
]
}
}
}Platform CLI
gemini mcp add dbconvert-streams-federated-sql npx -y @dbconvert/stream-mcpStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about DBConvert Streams (Federated SQL)
How to install DBConvert Streams (Federated SQL) in Claude Code?
Run claude mcp add streams -- npx -y @dbconvert/stream-mcp in your terminal. You can also install it under the full name using claude mcp add dbconvert-streams-federated-sql -- npx -y @dbconvert/stream-mcp.
Can the assistant modify or delete existing database records?
No, the server operates strictly in read-only mode. Its server-side filter admits only SELECT statements, ensuring the AI cannot alter schemas, edit rows, or change stream setups.
Which data formats and engines can be queried together?
The server handles PostgreSQL and MySQL connections alongside S3 object storage and local directories containing Parquet, CSV, or JSON files.
