Drift Locator for VS Code

VS Code extension for comparing database schemas across different instances.

Features

• Schema Comparison — Compare database schemas between two instances
• Comprehensive Object Support (PostgreSQL):
  • Tables (columns, indexes, constraints)
  • Views, Materialized Views
  • Functions, Procedures, Aggregates, Operators
  • Sequences, Triggers, Rules, Policies
  • Enum Types, Domains, Extensions, Comments
  • Foreign Tables, Partitions
  • Roles, Tablespaces, Publications, Subscriptions
  • Casts, FTS Configurations
• Visual Diff Viewer — Native VS Code side-by-side diff for schema comparison
• Export Reports — Automatic export of schema snapshots to .driftLocator/YYYY_MM_DD_HH_MM/

Requirements

• VS Code 1.85+
• PostgreSQL 12+ (other DBMS planned)

Usage

1. Open the Drift Locator view from the Activity Bar.
2. Click Add Connection and fill in the database credentials.
3. Select exactly two connections in the list.
4. Click Compare to analyze schema differences.
5. Review results in the built-in Diff Viewer and exported snapshot files.

Development

npm install
npm run compile
npm test
# Press F5 to run the extension in a new Extension Host window

License

MIT