🗄️ Database Inspector & Schema Profiler

Analyze Database

Inspect database structure, relationships, data quality, and potential schema design issues — 100% locally in your browser.

🔒 Privacy Guaranteed: Your database files and SQL code stay in your browser. No data is uploaded to any server.

100% Client-Side

📁

Drag & Drop Your Database File Here

Supports .SQL scripts, SQLite (.db, .sqlite, .sqlite3), CSV (single or multi-file), and JSON.

📂 Browse File

SQL Dialects: MySQL, PostgreSQL, SQLite, MariaDB, SQL Server • Data Formats: .db, .sqlite, .csv, .json

Database Analysis

Dialect: Generic SQL

Analyzed 0 tables and 0 records locally

Tables

Columns

Total Rows

Primary Keys

Foreign Keys

Indexes

Views

Database Health

out of 100

Schema Integrity 85%

Data Quality 80%

Referential Integrity 75%

Indexing Coverage 70%

Design Normalization 90%

🚨 Priority Issues

📊 Top Tables by Row Count

Issue & Anomaly Center

Detected potential data quality, missing indexes, missing primary keys, and referential integrity anomalies.

Tables & Schema Inspector

Table Name	Rows	Columns	Primary Key	Foreign Keys	Indexes	Issues	Action

Select Table:

Select Column:

Interactive ER Diagram

Visual entity-relationship map. Pan, zoom, click tables, and export.

💡 Scroll to zoom | Drag to pan

🔗 Referential Integrity Auditor

🔍 Inferred / Candidate Relationships

🌫️ NULL & Empty Value Ranking

👯 Duplicate & Uniqueness Audit

⚡ Indexing & FK Performance Audit

📏 Normalization & Naming Consistency

Auto-Generated Data Dictionary

Export full schema metadata to Markdown, CSV, JSON, or HTML documentation.

Table	Column	Data Type	Nullable	Default	PK	FK	Unique	Semantic Type

What Is Database Analysis & Inspection?

Database analysis is the process of auditing a database's structural schema, physical data types, primary and foreign key constraints, table relationships, indexing coverage, and underlying data quality metrics. Whether preparing a legacy database for cloud migration, auditing third-party application schemas, or debugging missing foreign keys, static and statistical database analysis reveals potential performance bottlenecks and schema anti-patterns before deploying code.

Core Metrics Audited by DataFrog Analyze Database

Schema Integrity: Checks primary key definitions, foreign key integrity, and table constraints.
Referential Integrity: Detects orphan records where child table foreign keys point to missing parent rows.
Indexing Coverage: Flags unindexed foreign key columns that cause full-table scans during relational joins.
Data Quality Profiling: Measures NULL percentages, duplicate rows, distinct counts, and numerical outliers.
Schema Normalization: Identifies First Normal Form (1NF) violations like comma-separated list values or repeating attribute columns.

100% Client-Side Browser Privacy

Traditional database inspection tools require database connection strings or uploading sensitive schema files to remote cloud servers. DataFrog Analyze Database runs entirely in your web browser memory using WASM and local JavaScript parsers. Your SQL code, SQLite binaries, CSV files, and JSON payloads never leave your computer.