database-inspector

Name: database-inspector
Availability: InStock
Author: haomingz

Explore SQLite and PostgreSQL schemas, relationships, and data previews with read-only access.

12|2|Updated Apr 21, 2026

Search Tags:#database #postgresql #schema #sqlite #read-only #er-diagram #data-preview

Ready to run

npx skills add https://github.com/haomingz/kimi-skills --skill database-inspector

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-inspector
Source: https://github.com/haomingz/kimi-skills/tree/main/skills/database-inspector
Command: npx skills add https://github.com/haomingz/kimi-skills --skill database-inspector

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2-binary, and includes scripts (resource) components.

What problem does it solve?

Automatically explore SQLite and PostgreSQL databases in a safe, read-only manner to inspect schemas, relationships, and sample data without risking data integrity.

Core Features & Use Cases

List tables and views with row counts to quickly understand data scope.
Describe table structures, foreign keys, and indexes to map relationships and constraints.
Preview data and generate Mermaid ER diagrams for architectural reviews and onboarding.
Use Case: A data engineer audits a new database before integration, verifying schemas and sample data at a glance.

Quick Start

Run the tool with the appropriate database type, providing the path to a SQLite file or a PostgreSQL DSN, then list tables, describe a table, preview data, or generate an ER diagram

Frequently Asked Questions about database-inspector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I inspect a PostgreSQL database schema without risking data modification?▼

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.

Can I generate an ER diagram from an existing SQLite database?▼

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.

Does this database inspection tool work with both SQLite and PostgreSQL?▼

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.

What's the best way to preview data in database tables during an audit?▼

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.

Do I need psycopg2 to explore PostgreSQL schemas with this tool?▼

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.