DBCrust - A powerful database CLI that understands PostgreSQL, MySQL, and SQLite.

DBCrust

A powerful database CLI that understands PostgreSQL, MySQL, and SQLite.

Pitch

DBCrust - The Database CLI That Thinks Like You Do

Intelligent PostgreSQL/MySQL/SQLite CLI built in Rust. Features context-aware autocompletion, SSH tunneling, Vault integration, and Docker auto-discovery. Perfect for Django developers with real-time N+1 detection.

Try instantly (requires uv)

uvx dbcrust docker://

Because your time is too valuable for clunky tools.

Description

DBCrust is an advanced command-line interface (CLI) tailored for modern databases, empowering developers with a seamless interaction experience across multiple databases including PostgreSQL, MySQL, and SQLite. Developed in Rust, DBCrust is designed for optimal performance, offering intelligent features such as context-aware autocompletion, SSH tunneling, and integration with HashiCorp Vault.

Key Features

Multi-Database Support: Effortlessly connect to PostgreSQL, MySQL, and SQLite with automatic detection for Docker containers.
Intelligent CLI: Enjoy context-aware autocompletion and syntax highlighting that enhance user productivity, alongside support for external editors.
Enterprise Ready: Secure your database connections with SSH tunneling and HashiCorp Vault integration.
Smart Performance Analysis: Utilize built-in EXPLAIN visualization tools and query optimization capabilities to enhance database performance.
Django ORM Analyzer: Detect N+1 queries in real-time, monitor performance, and receive optimization recommendations specifically for Django applications.
Python Library: Access a comprehensive programmatic interface with both CLI and Python APIs for more flexible integration.

Basic Usage Example

Establish database connections effortlessly, leveraging the intelligent autocompletion feature:

# Connect to PostgreSQL with autocompletion
dbcrust postgres://user:pass@localhost/mydb

# Connect to a detected Docker container
dbcrust docker://postgres-container

# Access saved session connections
dbcrust session://production_db

Advanced Features

Implement SSH tunneling for secure connections with:

dbcrust postgres://user:pass@db.internal.com/myapp --ssh-tunnel jumphost.com

For Django developers, real-time ORM performance analysis can be easily integrated:

# Enable real-time ORM analysis in Django settings
MIDDLEWARE = ['dbcrust.django.PerformanceAnalysisMiddleware', ...]

Explore the complete documentation to learn more about installation instructions, detailed guides, and full API references. DBCrust is not just a CLI; it's a comprehensive tool for optimizing and managing modern databases efficiently.

0 comments

No comments yet.

New comment