Declarative, SQL-like query language for building recommendation systems and search platforms, compiling to run across PostgreSQL, MongoDB, SQL Server, Oracle, and MariaDB.
github.com
Alternatives to
pg-dry-run
Best alternatives to pg-dry-run in 2026
Letting an AI agent run database writes directly is risky: an INSERT, UPDATE, or DELETE can silently cascade into related tables in ways that are hard to predict from the query alone. pg-dry-run turns each proposed write into a safe, inspectable preview before anything actually changes. pg-dry-run converts write operations into read-only transaction previews that show the exact row-level before/after values, flag foreign-key cascades, and warn about trigger or rule side effects. It uses xmin-based row version pinning so a preview can't silently go stale between when it's shown and when it's approved and applied — preventing the classic "preview said X, but by the time you approved it the data had changed" problem. Previews are JSON-serializable, so they can flow through an approval step in a separate process, and it supports custom database drivers, configurable row limits, and operation timeouts. It's MIT-licensed and free.
Quick comparison of pg-dry-run alternatives
| # | Tool | Best for | Price |
|---|---|---|---|
| 1 | Ingénieurs logiciels construisant des systèmes de recommandation, recherche ou ranking multi-bases. | — | |
| 2 | Développeurs indépendants et petites équipes cherchant une synchronisation de bases de données légère, sans plateforme de données d'entreprise. | — | |
| 3 | Développeurs, data engineers, et agents IA (utilisateurs de Claude, Cursor, Devin) ayant besoin d'un accès sûr et conscient du schéma à leurs bases de données | — | |
| 4 | Équipes data et utilisateurs d'agents IA (Claude Code, Cursor, Codex, Grok) voulant explorer des bases de données sans multiplier abonnements/clés API | — | |
| 5 | Développeurs Deno/TypeScript cherchant une base de données documents type CouchDB | — | |
| 6 | Équipes DevOps/SRE PostgreSQL sous exigences d'audit (SOC2, ISO27001, AWS FTR) | — | |
| 7 | Database developers and engineering teams documenting or sharing schemas | — | |
| 8 | Backend and full-stack developers who regularly work across more than one database engine. | — | |
| 9 | Teams building self-hosted cloud infrastructure, developers needing S3-compatible local development storage, and organizations seeking alternatives to expensive cloud storage. | — | |
| 10 | Équipes data engineering utilisant dbt/BigQuery et voulant valider automatiquement les changements de requêtes SQL | — | |
| 11 | Développeurs construisant des applications RAG, des bases de connaissances ou des systèmes de mémoire d'agents IA en local | — | |
| 12 | Développeurs d'agents IA et équipes construisant des systèmes RAG auto-hébergés | — |
#1
- ✓ Une seule syntaxe déclarative pour plusieurs bases (PostgreSQL, MongoDB, SQL Server, Oracle, MariaDB)
- ✓ Pipelines multi-étapes : recherche vectorielle + lexicale + scoring ML + reranking
#2
Open-source self-hosted tool for real-time data replication across multiple database engines (PostgreSQL, MySQL, MongoDB, Redis, SQLite, MariaDB). Eliminates need for Kafka or Debezium with lightweight synchronization via CDC, polling, or backfill.
syncle.dev
- ✓ Totalement gratuit et open source, sans restriction de licence
- ✓ Alternative légère aux solutions d'entreprise comme Kafka
#3
Free, open-source desktop SQL client for Postgres, MySQL, SQLite and 19+ other databases, with a built-in server that lets AI coding agents query your schema safely.
tabularis.dev
- ✓ gratuit et open source avec développement actif
- ✓ serveur MCP intégré pour les agents IA
#4
Free macOS desktop app for browsing and querying databases in natural language, built for teams pairing AI coding agents with real data.
valv.sh
- ✓ requêtes en langage naturel
- ✓ identifiants stockés localement
#6
Automatically restores your latest PostgreSQL backup into a throwaway container and proves it actually works, with an audit-ready report.
github.com
- ✓ prouve que les backups PostgreSQL se restaurent réellement, pas juste qu'ils existent
- ✓ fail-closed : un check qui ne tourne pas = échec, jamais silencieux
#7
Drop in a SQL schema, Prisma file, or pgModeler export and get back an interactive, shareable ER diagram — no install, no account needed.
mcdview.dev
- ✓ Free and open-source
- ✓ Multiple schema formats supported
#8
A desktop app for browsing and querying your databases that lets you ask questions in plain English instead of writing SQL, and works the same way whether your data is in Postgres, MySQL, MongoDB, or four other engines at once.
flyxl.github.io
- ✓ Single client for six different database engines
- ✓ AI-assisted query writing, error explanation, and index suggestions
#9
Open-source, self-hosted object storage that speaks the same S3 API as Amazon's cloud storage, so existing tools and scripts work unchanged while your files stay on your own servers.
alarik.io
- ✓ Full S3 API compatibility
- ✓ Fully open source, Apache 2.0 licensed
#10
A formal verification tool that mathematically proves whether a SQL query edit changes the result — not a heuristic guess, a definitive yes-or-no answer.
github.com
- ✓ Mathematical (SMT solver) proof of equivalence, not a heuristic guess
- ✓ Generates a concrete counterexample when queries diverge
#11
An embedded, single-file database that combines graph relationships, vector similarity search, and full-text search — built for local AI, RAG, and agent-memory apps.
github.com
- ✓ Graph + vector search (HNSW) + full-text (BM25) in one file
- ✓ No server to manage — portable embedded database
#12
A deterministic, Rust-built memory engine for AI agents, offering sub-millisecond recall over millions of stored memories.
github.com
- ✓ Sub-millisecond recall even at 1M+ memories, benchmarked on Rust
- ✓ Deterministic ranking (recency, reinforcement, context) beyond plain similarity search
FAQ about pg-dry-run alternatives
- What is the best alternative to pg-dry-run in 2026?
- Based on our selection, RecQL is the best alternative to pg-dry-run in 2026. Declarative, SQL-like query language for building recommendation systems and search platforms, compiling to run across PostgreSQL, MongoDB, SQL Server, Oracle, and MariaDB.. See our full ranking above to compare all options.
- Is pg-dry-run free?
- pg-dry-run is a paid tool. Several alternatives in our selection offer free or freemium versions.
- How many alternatives to pg-dry-run are there?
- mySelectas has listed 12 alternatives to pg-dry-run in the Databases & Storage category. Our selection is updated regularly to include the best options available.