Repository navigation
0.1.2
Full Changelog: https://github.com/AshBrud/dbinpect/commits/0.1.2
ποΈ DB Inspector v0.1.2
First Public Release on PyPI π
dbinpect is now available on PyPI! A powerful and flexible command-line tool to inspect and analyze any SQLAlchemy-compatible database.
β¨ Features
- π Complete Database Inspection - Analyze table structures, columns, types, and constraints
- π Data Visualization - Browse table contents with customizable row limits
- π Relationship Discovery - Automatically detect foreign keys and table relationships
- ποΈ Table Management - Safely delete tables with confirmation prompts
- π― Multi-Database Support - Works with PostgreSQL, MySQL, SQLite, and all SQLAlchemy-compatible databases
- βοΈ Flexible Configuration - Three configuration methods:
- CLI arguments (highest priority)
- Environment variables
.envfile
π Quick Start
pip install dbinpectThen use the analyze-db command:
# List all tables
analyze-db --database-url "postgresql://user:pass@host:5432/dbname"
# Inspect a specific table
analyze-db --database-url "postgresql://user:pass@host:5432/dbname" --table users
# View table data
analyze-db --database-url "postgresql://user:pass@host:5432/dbname" --table users --data 20π¦ What's Included
- Full command-line interface with comprehensive help
- Support for multiple database backends
- Flexible configuration system
- Safe table deletion with confirmation
- Detailed schema inspection
π§ Requirements
- Python 3.8+
- SQLAlchemy 2.0+
- Pydantic 2.0+
- pydantic-settings 2.0+
π Documentation
Full documentation is available in the README.
π Links
- PyPI: https://pypi.org/project/dbinpect/
- GitHub: https://github.com/AshBrud/dbinpect
- Issues: https://github.com/AshBrud/dbinpect/issues
π Acknowledgments
Built with:
- SQLAlchemy - Database toolkit
- Pydantic - Data validation
Made with β€οΈ for the Python community
Version courte (pour GitHub Release) :
```markdown
# ποΈ DB Inspector v0.1.2 - First Public Release
**dbinpect** is now available on PyPI! A powerful command-line tool to inspect and analyze any SQLAlchemy-compatible database.
## β¨ Key Features
- Complete database inspection (tables, columns, relationships)
- Data visualization with customizable limits
- Multi-database support (PostgreSQL, MySQL, SQLite, etc.)
- Flexible configuration (CLI, env vars, .env file)
- Safe table management with confirmation
## π Install
```bash
pip install dbinpect
π Usage
analyze-db --database-url "postgresql://user:pass@host:5432/dbname" --allFull documentation: README