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.