SchemaLens

SchemaLens brings Git-style version control to your PostgreSQL database schema. Every table, view, function, trigger, RLS policy, index, enum, and extension is introspected from your live database and written as plain SQL files in your repo — so schema changes are reviewable, diffable, and deployable like code.

The CLI mirrors Git workflows you already know: pull to snapshot your live database, status to see what changed, diff to compare environments, and deploy to apply changes — dry-run by default, transactional, with automatic rename detection to prevent data loss.

A linked web dashboard gives every pull and deploy an auto-synced snapshot with side-by-side SQL diffs and full history. A GitHub App posts schema diffs directly on pull requests. For AI workflows, a Model Context Protocol (MCP) server and Claude Code skill let coding agents inspect and manage your schema safely.

Works with any PostgreSQL database. One-click Supabase integration included.