Drift Locator

VS Code extension for comparing database schemas across different instances.

Features

• Schema Comparison — Compare database schemas between two instances of the same database engine
• Database Engines:
  • PostgreSQL 12+
  • MySQL 8.0+
  • SQLite
• Comprehensive Object Support:
  • PostgreSQL objects:
  • 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
  • MySQL objects:
  • Tables, columns, indexes, constraints
  • Views
  • Functions, procedures, parameters
  • Triggers, events, partitions
  • Schemas, grants, users
  • SQLite objects:
  • Tables, columns, generated columns
  • Indexes, including partial and expression indexes
  • Foreign keys
  • Views
  • Triggers
• 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+, MySQL 8.0+, or SQLite

Usage

1. Open the Drift Locator view from the Activity Bar.
2. Click Add Connection, choose the database engine, and fill in the connection details.
   • For PostgreSQL and MySQL, enter host, port, database, schema when applicable, username, and password.
   • For SQLite, choose the local database file from the file picker.
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.

Limitations

• Cross-database comparison is not supported.

Development

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

License

MIT

Also available for JetBrains IDEs.