Open-source, self-hosted API that unifies data from Apple Health, Garmin, Whoop, and Oura into AI-powered health insights.
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 | Health product teams and SaaS companies building on wearable data | — | |
| 2 | DBA, développeurs, analystes data cherchant un accès partagé et gouverné aux bases | — | |
| 3 | Développeurs voulant le modèle de données Datomic en open source sur object storage | — | |
| 4 | Développeurs macOS gérant leurs propres bases PostgreSQL | — | |
| 5 | Développeurs et DBA PostgreSQL cherchant une alternative moderne et légère | — | |
| 6 | Développeurs et DBA gérant plusieurs moteurs de bases de données | — | |
| 7 | DBA et développeurs gérant des bases PostgreSQL/MySQL/MariaDB/ClickHouse existantes | — | |
| 8 | Développeurs Python qui préfèrent des requêtes proches du SQL avec typage statique plutôt qu'un ORM à fort niveau d'abstraction | — | |
| 9 | Développeurs et ingénieurs data/DevOps travaillant avec PostgreSQL, MySQL ou MariaDB au quotidien | — | |
| 10 | Développeurs MongoDB, DBA et équipes DevOps ayant besoin d'authentification d'entreprise (SSH, Kerberos, LDAP, X.509) | — | |
| 11 | Ingénieurs logiciels construisant des systèmes de recommandation, recherche ou ranking multi-bases. | — | |
| 12 | 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. | — |
- ✓ Unified API for multiple wearables (Apple Health, Garmin, Whoop, Oura) with normalized data
- ✓ Fully open-source (MIT) with 2.5k GitHub stars and auditable scoring algorithms
Free, self-hosted browser SQL IDE covering 16 database engines, with ER diagrams, an AI query agent, and RBAC/audit trails built in.
- ✓ 16 moteurs supportés (SQL et NoSQL)
- ✓ SSO OIDC, RBAC et audit trail pour équipes
Open-source database inspired by Datomic, running on S3-backed storage with incremental Datalog queries and clients in multiple languages.
- ✓ Modèle de données Datomic en open source
- ✓ Construit sur S3/object storage, coût d'infra réduit
Native macOS Postgres GUI that turns plain-English questions into verified SQL, with on-device AI and no account required.
- ✓ Vérifie la requête générée contre le schéma réel avant exécution
- ✓ IA on-device disponible, sinon cloud avec votre propre clé
Free, local-first PostgreSQL IDE with a query EXPLAIN visualizer, JSONB browser, and live database health monitoring.
- ✓ Gratuit à vie, natif sur macOS/Linux/Windows
- ✓ Visualiseur EXPLAIN dédié et lisible
Free cross-platform database client covering MySQL, PostgreSQL, Oracle, SQL Server, MariaDB and SQLite in one lightweight app, no telemetry.
- ✓ 6 moteurs de bases de données dans un seul outil
- ✓ Migration de données cross-engine intégrée
Open-source tool that generates a Django-admin-style control panel for an existing database in about a minute, config-as-code via HCL.
- ✓ Gratuit et open source, aucun coût par siège
- ✓ Permissions fines + audit log complet avec diffs
A minimal Python ORM for MySQL, MariaDB and SQLite that favors writing explicit SQL-like queries with full static type checking over the query-building magic of larger ORMs.
- ✓ Design explicite proche du SQL, comportement prévisible
- ✓ Typage statique fort (73 surcharges) pour l'autocomplétion IDE
A free desktop app for browsing and moving data between PostgreSQL, MySQL and MariaDB databases without writing a one-off script every time you need to copy a table.
- ✓ Identifiants stockés dans le trousseau système, pas en clair
- ✓ Tunnel SSH et TLS pour connexions distantes
Free, open-source native desktop GUI for MongoDB with enterprise-grade authentication (SSH, X.509, Kerberos, LDAP) and no telemetry.
- ✓ Authentification d'entreprise complète (Kerberos, LDAP, X.509, SSH)
- ✓ Application native légère, pas d'Electron
Declarative, SQL-like query language for building recommendation systems and search platforms, compiling to run across PostgreSQL, MongoDB, SQL Server, Oracle, and MariaDB.
- ✓ Une seule syntaxe déclarative pour plusieurs bases (PostgreSQL, MongoDB, SQL Server, Oracle, MariaDB)
- ✓ Pipelines multi-étapes : recherche vectorielle + lexicale + scoring ML + reranking
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.
- ✓ Totalement gratuit et open source, sans restriction de licence
- ✓ Alternative légère aux solutions d'entreprise comme Kafka
FAQ about pg-dry-run alternatives
- What is the best alternative to pg-dry-run in 2026?
- Based on our selection, Open Wearables is the best alternative to pg-dry-run in 2026. Open-source, self-hosted API that unifies data from Apple Health, Garmin, Whoop, and Oura into AI-powered health insights.. 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.