A running log of features, fixes, and improvements to SchemaLens. Last updated April 28, 2026.
Programmatic schema diffing via POST /api/diff. Supports JSON and Markdown output, rate limiting, and CORS. Perfect for CI/CD and automation.
Anonymous usage tracking via /api/analytics, wired to Supabase for long-term querying. Localhost detection prevents dev noise.
New free micro-tool that lints SQL schemas for 10 common design issues: missing primary keys, unindexed foreign keys, missing timestamps, and more.
Visual form-based builder for CREATE TABLE statements across all 4 dialects. Generate correct DDL with one click.
Automatic detection of 6 dangerous patterns: dropped tables/columns, type narrowing, NOT NULL without defaults, missing FK indexes, and dropped constraints.
Full theming support across all 31+ pages. Respects system preference and persists user choice in localStorage.
PostgreSQL CREATE TRIGGER parsing, diffing, and migration generation. Detects added, removed, and modified triggers.
Full parser and migration generation for Oracle Database. Supports VARCHAR2, NUMBER, GENERATED ALWAYS AS IDENTITY, and tablespace clauses.
Free micro-tool that recommends indexes based on schema and query analysis. Detects missing FK indexes, redundant indexes, and duplicate coverage.
Supabase-powered cloud save for diffs with magic-link auth. Generate public read-only shareable links for team collaboration.
Generate interactive entity-relationship diagrams from SQL using Mermaid.js. Export as SVG or copy Mermaid source.
Interactive calculator that reveals the hidden annual cost of manual database migrations. Real-time sliders with team presets.
Export diff results as Prisma schema or Drizzle TypeScript definitions. Dialect-aware type mapping with @db attributes.
Weighted 0-100 risk rating for every diff based on breaking change severity. Exposed in app, API, and CLI.
Send diff results to any HTTPS endpoint after each comparison. HMAC-SHA256 signatures, test button, and settings UI.
Shared team diffs with Supabase auth. Version history for every saved diff. Load any previous version instantly.
Diff open SQL files directly from VS Code. Auto-detects dialect from filename and opens SchemaLens with both schemas pre-filled. Install from the VS Code Marketplace.
SQL Validator, SQL Formatter, Schema Docs, CSV to SQL, JSON to SQL, Schema Health Check, CREATE TABLE Generator, SQL Index Analyzer, ER Diagram Generator, and Migration Cost Calculator.
Comprehensive content library covering schema diffing, migration safety, CI/CD integration, SQL best practices, database design, and cost analysis.
Initial release of the browser-based schema diff tool. Custom SQL parser for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. Semantic diff engine with migration generation.