Skip to content

Releases

0.2.1

Choose a tag to compare

@AshBrud AshBrud released this 19 Nov 16:01
50d7950

What's Changed

  • Refactor README.md and env.example for clarity and consistency by @AshBrud in #1
  • Dbi v0.2.1 by @AshBrud in #2

New Contributors

Full Changelog: 0.1.2...0.2.1

0.1.2

Choose a tag to compare

@AshBrud AshBrud released this 19 Nov 02:32

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
    • .env file

🚀 Quick Start

pip install dbinpect

Then 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

🙏 Acknowledgments

Built with:


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" --all

Full documentation: README

PyPI: https://pypi.org/project/dbinpect/