A modern, fast SQLite database manager with an interactive terminal UI. Built with uv for lightning-fast dependency management and featuring comprehensive table creation, metadata storage, and database operations.
🤖 AI-Powered Development: This project was created collaboratively with Claude Sonnet 3.5 using Zed's innovative agentic mode, showcasing the future of AI-assisted software development.
- 🚀 Lightning Fast: Built with uv package manager (10-100x faster than pip)
- 📊 Interactive Database Management: Terminal-based UI with guided workflows
- 🛠️ Smart Table Creation: Both interactive guided mode and manual SQL definition
- 🏷️ Metadata Management: Store database descriptions, purpose, owner, and tags internally
- 🔍 Schema Inspection: Beautiful formatted table schemas and column information
- Enhanced Data Entry: Real-time feedback, validation, and error handling
- UI Explorer: Intuitive interface for users unfamiliar with database concepts
- Multi-Database Support: Manage multiple databases with organized storage
- Modern Python Tooling: Uses uv, Python 3.12+, and modern best practices
Install uv - the fast Python package manager:
# macOS/Linux
curl -LsSf https://astral.sh/uv/install.sh | sh
# Windows
powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"# Clone the repository
git clone https://github.com/0xnuminous/everything-db-manager.git
cd everything-db-manager
# Set up the environment (creates .venv automatically)
uv sync
# Verify installation
uv run verify_setup.py# Start the interactive database manager
uv run everything_ui.py
# Or use the dedicated run script
uv run run.py# Run the basic usage demo
uv run example_usage.py
# See table creation examples
uv run table_creation_demo.py
# View UI improvements showcase
uv run ui_improvements_demo.py- Open/Create Database - Create new or open existing database with metadata
- List All Databases - View all databases with descriptions and info
- List Tables - Show tables in current database
- Create Table - Interactive or manual table creation with validation
- Execute Query - Run custom SQL commands
- Show Table Schema - Display formatted table structure
- Insert Data - Add data with guided input and validation
- View Table Data - Browse table contents with pagination
- Show Database Info - View database metadata and statistics
- UI Explorer - Beginner-friendly interface for non-technical users
- Close Database - Close current database connection
- Exit - Quit the application
- Guided Process: Step-by-step column definition
- Flexible Data Types: Accepts common abbreviations (
int,string,float, etc.) - Smart Constraints: PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT values
- Auto Increment: Available for INTEGER primary keys
- Real-time Preview: Shows table definition as you build
- SQL Definition: Direct column definition entry
- Advanced Features: CHECK constraints, foreign keys, complex types
- Syntax Validation: Prevents common errors before creation
The UI Explorer provides an intuitive interface for users who aren't familiar with database terminology:
- Plain Language: Uses terms like "storage space" instead of "table"
- Guided Workflows: Step-by-step processes for common tasks
- Visual Data Display: Clean, formatted views of your information
- Smart Search: Find data without writing SQL queries
- Data Summaries: Overview of all stored information
- 📊 Browse My Data - See what information is stored
- ➕ Add New Information - Create new storage spaces with guided setup
- ✏️ Update Existing Information - Modify stored data
- 🔍 Search & Filter Data - Find specific items easily
- 📈 Get Data Summary - Overview of all your data
- ❓ Help - Explanations of concepts and features
Creating a "customers" storage space:
1. Choose a name: "customers"
2. Add fields step-by-step:
- Name (Text/Words - Required)
- Email (Text/Words - Required)
- Age (Numbers - Optional)
- Active (Yes/No - Optional)
3. Automatically creates proper database structure
Table name: users
Column 1: id (INTEGER, Primary Key, Auto Increment)
Column 2: username (TEXT, Not Null, Unique)
Column 3: email (TEXT, Not Null, Unique)
Column 4: created_at (TEXT, Default: CURRENT_TIMESTAMP)
Each database automatically stores:
- 📅 Creation and modification dates
- 📝 Description and purpose
- 👤 Owner/creator information
- 🏷️ Tags for organization
data/
├── .gitkeep # Maintains directory structure
├── my_project.db # Your database files
└── inventory_system.db # With embedded metadata
- Python: 3.12+ (managed by uv)
- Package Manager: uv
- Database: SQLite 3 (included with Python)
- OS: Windows, macOS, Linux
- Development Guide - Setup and development workflow
- Table Creation Guide - Comprehensive table creation reference
- UI Improvements - User experience enhancements
- UV Migration - Modern tooling adoption
# Setup development environment
uv sync
# Run application
uv run everything_ui.py
# Add new dependencies
uv add package-name
# Add development dependencies
uv add --dev pytest
# Run verification tests
uv run verify_setup.pyeverything-db-manager/
├── data/ # Database storage
├── everything_db.py # Core database operations
├── everything_ui.py # Terminal interface
├── run.py # Application entry point
├── pyproject.toml # Project configuration
├── uv.lock # Dependency lock file
└── docs/ # Documentation files
This project demonstrates the cutting-edge capabilities of AI-assisted software development using:
- Collaborative Design: Human creativity combined with AI technical expertise
- Iterative Enhancement: Real-time feedback and improvement cycles
- Modern Tooling Integration: Seamless adoption of uv, Python 3.12+, and best practices
- Documentation-First: Comprehensive guides generated alongside code development
- Quality Assurance: Built-in validation, testing, and verification systems
- Full-Stack Development: From database design to user interface implementation
- Code Architecture: Professional project structure and modular design patterns
- User Experience Design: Intuitive workflows and error handling improvements
- Technical Writing: Complete documentation suite including guides and examples
- DevOps Integration: Modern packaging, dependency management, and deployment
- Real-time Collaboration: Seamless human-AI code editing and review
- Context Awareness: Understanding of entire project scope and dependencies
- Tool Integration: Direct access to development tools and environments
- Quality Control: Automated testing and verification during development
This project serves as a proof-of-concept for the future of software development, where AI assistants can collaborate as full development partners while maintaining human creativity and oversight.
Schema Display - Before:
(0, 'id', 'INTEGER', 0, None, 1)
(1, 'name', 'TEXT', 1, None, 0)
Schema Display - After:
Column Type Nullable Key Default
------------------------------------------------------------
id INTEGER YES PRIMARY
name TEXT NO
- ✅ Flexible Data Types:
int→ INTEGER,string→ TEXT - ✅ Beautiful Formatting: Clean, readable table displays
- ✅ Smart Validation: Table existence checks with suggestions
- ✅ Real-time Feedback: Immediate confirmation of actions
- ✅ Error Recovery: Helpful messages with next steps
Built with uv for exceptional performance:
- 10-100x faster dependency resolution vs pip
- Instant environment creation and management
- Parallel package installation by default
- Efficient caching for repeated operations
- Fork the repository
- Create a feature branch:
git checkout -b feature/amazing-feature - Setup development environment:
uv sync - Make your changes and test:
uv run verify_setup.py - Commit your changes:
git commit -m 'Add amazing feature' - Push to the branch:
git push origin feature/amazing-feature - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
- Claude Sonnet 3.5 - AI assistant that collaboratively designed and built this entire project
- Zed Editor - Revolutionary agentic mode enabling seamless AI-human collaboration
- Modern AI Development - Showcasing the future of software creation through AI partnership
- uv - Amazing Python package manager by Astral
- SQLite - Reliable, lightweight database engine
- Python Community - For excellent tooling and libraries
Made with ❤️ and powered by uv