ZenDB is an all-in-one database toolkit designed to simplify and enhance database management tasks. Whether you're a seasoned database administrator or a beginner, ZenDB provides a comprehensive set of tools and resources to optimize your database skills.
-
Type Optimizer 🧬: Select the most efficient data types for your columns. This tool provides recommendations to optimize storage and query speed based on your dataset.
-
Schema Visualizer 🔍: Get a comprehensive overview of your entire database schema. This tool helps you visualize the relationships between tables, fields, and keys to ensure optimal structure and design.
-
Query Estimator ⏱️: Get an instant estimate of your query's complexity. This tool helps predict performance and suggests optimizations for faster query execution.
-
Normalization 🧹: Simplify the process of normalizing your database. This tool assists in organizing your data into efficient structures while eliminating redundancy and ensuring consistency.
-
Index Analyzer 📊: Evaluate and improve the performance of your database indexes. This tool helps you discover bottlenecks and suggests ways to streamline your indexing strategy.
-
ERD Generator 🗺️: Quickly generate ER diagrams using either a Prisma schema or simple text-based schema. Visualize your database structure and relationships with ease.
-
Character Bit Size 📏: Ensure your database fields are using optimal character lengths. This tool helps you identify and adjust field lengths to save space and improve performance.
-
Blogs and Resources 📚: Access daily updated blogs and curated learning resources to stay on top of database trends and best practices.
-
Community-Driven Tips 💡: Access a wealth of knowledge shared by our vibrant community of database professionals.
-
Daily Updated Blogs 📝: Stay informed with our regularly updated blog posts on database trends and best practices.
-
Learning Resources 🎓: Enhance your skills with our curated collection of educational materials.
To get started with ZenDB, follow these steps:
-
Clone the repository:
git clone https://github.com/devrabbani/zendb.git -
Navigate to the project directory:
cd zendb -
Install dependencies:
npm install -
Set up environment variables: Create a
.env.localfile in the root directory and add necessary environment variables. -
Run the development server:
npm run dev -
Open http://localhost:3000 in your browser to see the application.
We welcome contributions from the community! If you'd like to contribute to ZenDB, please follow these steps:
- Fork the repository.
- Create a new branch for your feature or bug fix.
- Make your changes and commit them with descriptive commit messages.
- Push your changes to your fork.
- Submit a pull request to the main repository.
ZenDB is released under the MIT License.
If you encounter any issues or have questions, please file an issue on our GitHub issue tracker.
ZenDB - Empowering database professionals and enthusiasts to achieve database zen. 🧘♂️💻