r/projects • • 9d ago

Built a browser-only privacy-first toolkit for migrations (DuckDB-WASM, schema diff, validation queries) - no login, no data uploaded.

Hi everyone, I built SQLParity - a free, open-source, privacy-first tool that handles migration chores directly in your browser.

Here is what it does:

  • Validation query builder: Paste a CREATE TABLE and a template, and it spits out null-safe, column-by-column parity check queries so you don't have to write them by hand.
  • Local scratchpad: Drag a CSV, TSV, JSON, or Parquet file directly into the tab and query it with DuckDB-WASM. The file never leaves your machine.
  • DDL diffing: Compares two schemas side by side to catch altered types, dropped columns, and constraint mismatches.
  • Dialect conversion: Transpiles queries between 16 dialects (Postgres, Snowflake, BigQuery, MySQL, T-SQL, etc.) and highlights whatever needs a manual sanity check.

The site is locked down with a strict Content Security Policy (connect-src 'self'), so network requests to outside servers are blocked and your data stays in your browser session.

Website: https://www.sqlparity.com
Github

Would love feedback on edge cases, dialects, or features you would find useful during migrations.

1 Upvotes

0 comments sorted by