observe-lens-db

Query databases read-only to see what state data is in while debugging, testing or answering a question: PostgreSQL, MySQL or MariaDB and MongoDB (including AWS RDS, Aurora and DocumentDB), directly or through an SSH tunnel, with a guard that only lets SELECT-style SQL and read-only Mongo expressions through. Discovers tables, columns and collections before querying. Use this whenever the user gives an order, customer, account, request or record id and wants to know what was stored, which status or error a record has, whether a migration or job changed data, or why the data does not match what the UI or an API shows, even if they do not say database, SQL, psql or Mongo. Read-only: for writing migrations, changesets, DDL or data fixes use a development skill instead.

Version

1.0.1

License

Apache-2.0

Compatibility

Python 3.11+ (standard library only) on macOS, Linux or Windows, plus the engine's CLI (psql, mysql or mongosh) and ssh for tunnels. Needs an instance in ~/.config/observe-lens/db (see references/setup.md).