database-inspector

To inspect a PostgreSQL database schema safely, use a read-only explorer that restricts write operations while exposing table structures and relationships. This enforces read-only connections to describe schemas, foreign keys, and row counts without risking data modification.

Yes, you can generate an ER diagram from an existing SQLite database by discovering foreign key relationships and rendering them visually. This produces Mermaid ER diagrams directly from SQLite file structures to map table relationships for architectural reviews.

Yes, this database inspection tool works with both SQLite and PostgreSQL. You provide a path to a SQLite file or a PostgreSQL DSN, and it reads table schemas, indexes, and sample data across both database types using enforced read-only access.

The best way to preview data in database tables during an audit is using a read-only inspector that limits query scope to safe SELECT operations. This previews sample rows and lists table row counts to verify data scope without risking integrity.

Yes, you need psycopg2 to explore PostgreSQL schemas with this tool. The Skill requires the psycopg2-binary dependency to establish read-only DSN connections, query table structures, and extract foreign key metadata for safe schema exploration.