PeepDB
PeepDB:open-source CLI tool to quickly view database tables.
Listed in categories:
Open SourceGitHubDeveloper Tools
Description
peepDB is an open-source command-line tool and Python library designed for developers and database administrators who need a fast and efficient way to inspect their database tables without writing SQL queries. It supports MySQL, PostgreSQL, and MariaDB, making it lightweight, secure, and incredibly easy to use.
How to use PeepDB?
To use peepDB, install it via pip with the command 'pip install peepdb'. Save your database connection details using 'peepdb save connectionname dbtype mysql/postgres/mariadb host host user user database database'. You can then view tables, paginate through data, and choose output formats using simple command-line commands.
Core features of PeepDB:
1️⃣
Multi-Database Support: Works with MySQL, PostgreSQL, and MariaDB
2️⃣
Quick Data Inspection: View all tables or a specific table with a simple command
3️⃣
User-Friendly CLI: Easy-to-use command-line interface powered by Click
4️⃣
Secure Local Storage: Securely store database connection details with encryption on your local machine
5️⃣
Formatted Output: View data in a clean formatted table or JSON format
Why could be used PeepDB?
| # | Use case | Status | |
|---|---|---|---|
| # 1 | Database administrators can quickly inspect tables without writing SQL queries. | ✅ | |
| # 2 | Developers can easily manage and view database connections and data. | ✅ | |
| # 3 | Users can handle large datasets efficiently with pagination. | ✅ | |
Who developed PeepDB?
peepDB is developed by a team of contributors including Evangelos Meklis, Aherontas Petros Savvakis, and Arthure Antony Varghese, who are dedicated to providing a fast and efficient tool for database management.