dbconvert

@dbconvert.bsky.social

Database IDE + migration + CDC for PostgreSQL, MySQL, Snowflake, files, and S3. Posts about CDC, DuckDB, Parquet, schema validation, and database migration failures. streams.dbconvert.com

Migrating MySQL → PostgreSQL is two jobs. Tools move the data. Job two: every query in MySQL's dialect still needs rewriting. AI translates — old news. New: it proves the translation. One federated query, both live DBs, MATCH/DIFF per row. streams.dbconvert.com/blog/using-c...

MySQL vs PostgreSQL Syntax: AI Query Translation, Verified | DBConvert Streams

Some dialect differences fail loudly. The dangerous ones return different numbers with no error. Real error messages, a live verified example, and the AI loop that proves a translation.

streams.dbconvert.com

Migrating MySQL → PostgreSQL? Schema + data move clean. The work is the MySQL-isms: AUTO_INCREMENT, TINYINT(1)→boolean, unsigned ints, 0000-00-00 dates, ON DUPLICATE KEY→ON CONFLICT — plus stored procedures no tool converts. Honest breakdown 👇 dbconvert.com/blog/how-to-...

Migrate MySQL to PostgreSQL: Data Types & SQL Rewrites

A practical guide to moving MySQL to PostgreSQL: data-type mapping, copy-paste SQL rewrites (AUTO_INCREMENT, ENUM, unsigned, backticks), and low-downtime CDC cutover.

dbconvert.com

Updated guide: Oracle → PostgreSQL migration. The clean split: schema and data can be automated, but SQL dialect, PL/SQL, views, validation, and cutover still need engineering work. No magic button, just the parts that actually matter. dbconvert.com/blog/how-to-...

Migrate Oracle to PostgreSQL: Data Types & SQL Rewrites

A practical guide to moving Oracle to PostgreSQL: data-type mapping, copy-paste SQL rewrites (ROWNUM, CONNECT BY, NVL), the PL/SQL reality, and cutover options.

dbconvert.com

Wrapping queries as MCP tools is a weekend. Making a database MCP server safe for real data is the work: read-only by default, narrow tools, per-request scoping, bounded results. The tools are the easy part. The boundary is the product. #MCP #AI streams.dbconvert.com/blog/what-a-...

What a good database MCP server gets right

Connecting an AI assistant to a database over MCP is mechanically simple. Making it safe is not. Where the boundary lives, how much access you hand over, and what comes back - notes from building the ...

streams.dbconvert.com

DuckDB made cross-source SQL feel simple. Postgres table + Parquet file + S3 path? Fine. The annoying part starts when the query needs to be repeated: - saved connections - credentials - schema checks - exports - validation - logs - reruns That is where "just a query" quietly becomes infrastructure.

Database migrations rarely fail because copying rows is hard. They fail around the boring edges: schema drift foreign keys snapshot boundaries CDC handoff retries checkpoint timing validation after the move The transfer is one part. The workflow around it is usually where the mess starts.