📦
kunalDB is a simple, interactive, file-based database management system written in Python. It allows you to create, edit, delete, import, export, and visualize tabular data using a custom .kunal file format. The tool is designed for learning and small-scale data management tasks, with a command-line interface and basic features similar to a spreadsheet or CSV editor.
- Add, Edit, Delete Records: Manage your data records interactively.
- Custom Table Structure: Define your own fields/columns.
- Import/Export:
- Import data from CSV files.
- Export data to CSV or HTML for use in Excel or web pages.
- Table Visualization: Display data as formatted tables in the terminal.
- Search: Find records using regular expressions.
- Plot Graphs: Simple ASCII bar graphs for numeric data.
- Multiple Databases: Switch between different
.kunalfiles. - File Overwrite Protection: Prevent accidental data loss with overwrite confirmations.
git clone https://github.com/kunald08/KunalDB.git
cd KunalDBOnly one optional dependency for colored output:
pip install coloramaApp works without
colorama, but terminal output won't be colored.
python kunalDB.pyMake a selection:
1) Add a record
2) Delete a record
3) Edit a record
4) Overwrite the file
5) Display as table
6) Display as csv
7) Plot a Graph (BETA)
8) Find in table
9) Import CSV
10) Export As...
11) Switch DB
12) EXIT
- Data is stored in binary
.kunalfiles using Python'spicklemodule. - Each file contains a table structure (field names) and records.
- Pure Python (no SQL used)
- Uses OOP (
dataClass) for record encapsulation - Highlights matching records using terminal styling
- ASCII graph plotting with scaling
- This project is for educational and small-scale use only.
.kunalfiles are not compatible with other database systems.- Always back up your data before overwriting files.
Kunal Dharpure
Made with ❤️ for CLI nerds
MIT License © 2025 Kunal Dharpure