Give your IDE assistant the real schema
Cursor or VS Code can read actual columns, types and indexes instead of inferring them from stale code.
“Write the migration to add this column, matching the types already in the production orders table.”
MCP SERVER
Claude, Cursor, VS Code and Codex explore your schemas, query across databases, files and S3, and diagnose CDC — and never write.
Cursor or VS Code can read actual columns, types and indexes instead of inferring them from stale code.
“Write the migration to add this column, matching the types already in the production orders table.”
One federated SELECT can reconcile a database, local files and S3 without a staging table or throwaway script.
“Is customers.parquet in S3 still in sync with the live customers table?”
Before a large load, compare schemas across connections for type mismatches, missing primary keys, and CDC risks.
“Compare orders on my Postgres source with the MySQL target. What will break, and what is only a warning?”
It pulls status, stats, recent errors, and stream configuration together instead of making you cross-check each view.
“My MySQL → PostgreSQL CDC stream stopped overnight. Check status and recent errors, and tell me what to fix.”
Same tools either way. What differs is where the sources come from — and whether there are streams to report on.
Hand it connection strings — PostgreSQL, MySQL, S3, a folder of Parquet or CSV — and it serves exactly those. Nothing to install: you paste one line into your AI client's settings and it starts the server itself.
npx @dbconvert/stream-mcp "postgres://user:pass@host:5432/shop"Also ships as a Claude Desktop extension and a container image.
Standalone setupReads the installation you already run: the same connections and schemas the app shows, plus the state of your migrations and CDC streams.
https://<your-host>/mcp; authenticate with your API key and Install ID.Either way the server runs beside your data, on your machine or in your stack. It is never a shared AI endpoint on streams.dbconvert.com. Prefer AI Chat inside the app?
These came back from a live workspace — schema, stream state and data included.
Stream troubleshooting
You
My MySQL → PostgreSQL CDC stream stopped overnight. List my streams, check status and recent errors, and tell me what to fix.
AI
Found it — the latest run FAILED with Error 1049: Unknown database 'target'. The CDC source points at a database that doesn’t exist on the MySQL server. Fix: create it (or correct the database name), then restart.
Analytics on live data
You
What are my top film categories by rental revenue? (sakila sample)
AI
Sports — $5,314.21 Sci-Fi — $4,756.98 Animation — $4,656.30 Drama — $4,587.39 Comedy — $4,383.58 Joined category → film_category → film → inventory → rental → payment, ran in ~55 ms.
Full examples: plain-English SQL and federated validation.
The server can inspect and advise. It cannot change anything.
Only SELECT and WITH … SELECT pass the server-side filter. INSERT, UPDATE, DELETE, DROP, ALTER and CREATE are rejected before they reach the database.
The AI never sees passwords and cannot create or edit connections. Secrets are redacted from everything it reads.
It cannot start, stop, pause or reset streams. It surfaces the status, error and recommended fix; you run the action.
The server runs on your machine or in your stack and responds only to your client’s requests.
One connection string is enough to start, and a few minutes to wire it to a live workspace.