DATABASE SCHEMA INSPECTOR

See what your SQL schema is actually doing.

Paste or load a SQL schema and get an instant structural readout: tables, keys, relationships, indexes and common design risks. Everything runs locally in your browser.

Analyze a schema

✓ No API keys✓ No database connection✓ Local-only analysis

schema.sql

CREATE TABLE orders (
  id BIGINT PRIMARY KEY,
  customer_id BIGINT,
  total DECIMAL(12,2),
  created_at TIMESTAMP,
  FOREIGN KEY (customer_id)
    REFERENCES customers(id)
);

5tables4relations3review items

WORKSPACE

Inspect a schema

Analysis stays in this tab

SQL inputCREATE TABLE statements work best

Open .sql file

Schema scoreHeuristic design review

Ready

—

Load a schema

SchemaLens will summarize structure and flag patterns worth reviewing.

0 Tables0 Relations0 Indexes0 Findings

Table mapDetected columns, keys and relationships

Run an analysis to populate the schema map.

FindingsPractical review prompts, not absolute rules

No findings yet.

WHAT IT CHECKS

Useful signals before you ship

Structure

Counts tables and columns, identifies primary keys, unique constraints and foreign-key relationships.

Index hygiene

Highlights foreign-key columns that do not appear to have explicit indexes in the supplied schema.

Type review

Surfaces risky heuristics such as money stored in floating types, very wide text fields, or suspicious generic IDs.

Relationship clarity

Shows each detected relationship in a compact map so teams can understand a schema without opening a DB client.

ZERO-BUILD DEPLOYMENT

Built for shared hosting, GitHub Pages or any static host.

There is no backend and no dependency install. Upload the folder contents to the document root for schemalens.valron.co.ke, then point the subdomain to that directory.

Create the subdomain.Use schemalens.valron.co.ke in cPanel or your DNS/hosting control panel.
Upload the project.Place index.html and the assets folder in the subdomain document root.
Enable HTTPS.Issue or renew the SSL certificate, then force HTTPS at hosting level if available.
Publish the repo.Commit the same files to GitHub. No secrets or environment variables are required.