01
ERD
Entity diagrams per schema, keys and cardinality drawn from real constraints.
Free
No database connection. Just your scripts.
Leap from SQL to answers.
Toss your exported SQL scripts in the pond. SchemaFrog fishes out the data dictionary, diagrams, lineage and plain-English business logic, with every fact cited to its file and line.
Free to try, no card. Speaks SQL Server, PostgreSQL, Oracle, MySQL, and any database that can script itself out as SQL.
Packages / northwind-erp / v3
412 files read
- 01ERDTables, keys and joins from real constraints.See the shape in seconds
- 02Data lineageWhere each table’s data comes from and goes.Trace a bad number to its source
- 03ArchitectureLayers, schemas and systems on one page.Brief the boss without a whiteboard
- 04Data dictionaryEvery column: type, keys, source line.Stop guessing what CustStat2 means
- 05SQL object inventoryEvery proc, view, function and trigger.Know exactly what you own
- 06Business logicWhat each proc does, in plain English.Read the rules, skip the T-SQL
- 07Source-to-targetWhat writes each field, and how.Migrations without archaeology
- 08Impact analysisEverything that touches a table or column.Change things without breaking things
- 09Job scheduleAgent jobs, steps and run order.Know what runs at 2 a.m.
- 10Sensitive dataPersonal fields and who can reach them.Answer the auditor in an afternoon
- 11Data quality rulesConstraints and checks in one rulebook.Catch bad data at the door
- 12Glossary & questionsBusiness terms, plus what code can’t say.Onboard new people faster
- 13Ask the package (AI chat)Plain-English answers that cite file and line, and admit what isn’t there.Answers with receipts, not guesses
Never touches your database
Every fact comes with a receipt
Gone in one click when you say so
How it works
Three hops. Zero credentials.
You hand over files, not a connection string. SchemaFrog reads every line like a very patient senior engineer who never needs a coffee break.
01
Export your scripts
Script out tables, views, procs and jobs with the tools you already use. Zip the folder. Several databases? One folder each.
SSMSSSDTpg_dumpOracle DDL
02
SchemaFrog dives in
Every object parsed, every dependency traced, every secret hauled up to the surface and pinned to the file and line it came from.
412 files
03
Browse, filter, ask
Open a package of thirteen deliverables. Filter by schema or system, export to Excel, or just ask a question.
HTMLExcelQ&A
What you get
Thirteen deliverables. One splash.
Your database is a black box until something reads the code. SchemaFrog reads every line that actually runs and spills its secrets: the documentation your team keeps promising to write, done.
02
Data lineage
Column-level flow from source tables through procs and views.
Free03
Architecture
Layers, schemas and systems on one page your manager can read.
Pro04
Data dictionary
Every table and column with type, nullability and source line.
Free05
SQL object inventory
Tables, views, procs, functions and triggers, counted and sorted.
Free06
Business logic
What each proc really does, in plain English. No decoder ring needed.
Free taste07
Source-to-target mapping
Field-by-field mappings with the transform in between.
Pro08
Impact analysis
Poke one column, see every object that ripples.
Free09
Job schedule
Agent jobs and steps, when they run and what they touch.
Free10
Sensitive data & access
Likely PII columns and the roles and grants that reach them.
Pro11
Data quality rules
Constraints, checks and defaults gathered into one rulebook.
Free12
Glossary & open questions
Business terms, plus the things the code alone cannot answer.
Pro13
Ask the package (AI chat)
Ask in plain English. Every answer cites the deliverable and the file and line it came from, and says “not in the package” instead of guessing.
Free taste
Cross-database
Several databases, one pond.
Upload every system you own. SchemaFrog follows the three-part names between them, so the hidden handshakes finally surface.
- Cross-database reads and writes, cited both ends
- Databases you forgot to export get flagged, not guessed
HRSQL Server
dbo.Employees
dbo.Departments
dbo.Contracts
FinanceSQL Server
dbo.PostPayroll
dbo.Ledger
dbo.CostCentres
Finance.dbo.PostPayroll reads HR.dbo.Employees
Finance/Procs/PostPayroll.sql:88
2 systems · 37 cross-database links
Ask the package
Answers with receipts.
Ask in plain English. Every claim links back to a deliverable id. When the export doesn't say, SchemaFrog says “not in the package” instead of telling tall tales.
Ask northwind-erpAnswers from package v3 only
What breaks if I drop Sales.Orders.Status?
Three objects depend on it, and one nightly job writes to it.
- View Sales.vOpenOrders filters on it [IMP:Sales.Orders]
- Sales.usp_CloseOrder sets it to 'Shipped' after invoicing [BL:R-004]
- Job NightlyFulfilment, step 2, updates it [JOB:J-07]
Not in the package: app code, reports and APIs outside your SQL export. Check those before you drop it.
Ask about tables, procs, jobs…
Pricing
Dip a toe for free. Dive in with Bullfrog.
Tadpole
Free. One database, a real taste.
$0forever
- One database, up to 50 tables
- Data dictionary, ERD and object inventory
- Lineage, impact analysis and data quality rules
- Plain-English write-ups of your 3 biggest procedures
- 5 questions to Ask the package
- Package kept for 14 days
Bullfrog
Pro. Every deliverable, every database.
$XXper month
- Everything in Tadpole, no table limit
- Several databases with cross-database lineage
- Plain-English business logic for every object
- Source-to-target mapping and sensitive data map
- Unlimited questions with cited answers (fair use)
- Excel export, glossary and open questions
- Re-upload anytime to refresh your package
Cancel anytime. Your uploads and packages delete with one click.