dbsurveyor

#

Status: Active

dbsurveyor is a two-part toolchain (collector + postprocessor) for fast database schema discovery and limited data sampling across engines like PostgreSQL, MySQL/MariaDB, MSSQL, SQLite, and MongoDB. The collector runs where credentials are valid and produces a portable .dbsurveyor.json(.zst/.enc) file; the postprocessor works fully offline to generate reports, diagrams, and reconstructed SQL.

Highlights

#

• Schema + sample extraction with throttle control
• Portable outputs with optional compression and AES-GCM encryption
• Markdown/JSON reports and SQL reconstruction; Pro adds diagrams, classification, HTML
• Rust static binaries; no telemetry; human-inspectable outputs
• Pluggable engine adapters with feature flags or plugins

Usage

#

Collect on the target (connected to DB):

dbsurveyor-collect --engine postgres --dsn postgresql://user:pass@host:5432/db --out survey.dbsurveyor.json.zst

Process offline:

# Markdown report
dbsurveyor report survey.dbsurveyor.json.zst --out report.md

# Reconstruct CREATE TABLE SQL
dbsurveyor reconstruct survey.dbsurveyor.json.zst --out schema.sql