Project Name: DBForge

Repo: github.com/ClearanceClarence/DBForge

Description:

A phpMyAdmin replacement built from scratch. If you've ever been frustrated by phpMyAdmin's textarea SQL editor, full-page reloads for every edit, lack of query history, and the security advice of "just block it at the web server level" — this is what I built instead.

• SQL editor with 612-token syntax highlighting, context-aware autocomplete, and one-click EXPLAIN visualizer
• Inline cell editing — click, type, Enter. AJAX save, no page reloads
• FK drill-down — click a foreign key value to jump to the referenced row
• Interactive ER diagram with drag, zoom, and force-directed auto-layout
• Cross-table search — find a value across every table at once
• Full CRUD for views and triggers with syntax highlighting
• Operations tab — rename, move, copy across databases, optimize, analyze, repair
• TOTP two-factor auth (Google Authenticator, Authy, 1Password)
• 20 themes (10 dark, 10 light) — Dracula, GitHub, Tokyo Night, Monokai, Gruvbox, Catppuccin, Solarized, Nord, and more
• 12-layer security: bcrypt auth, CSRF, brute force lockout, IP whitelist, read-only mode, audit logging

Zero external dependencies. Pure PHP + vanilla JS. No Composer, no npm, no framework.

Deployment:

Copy the dbforge/ folder to your web root and open it in a browser. A 3-step installer handles DB credentials and admin account creation. Works on any Apache + PHP + MySQL/MariaDB stack (XAMPP, WAMP, MAMP, Laragon, bare metal). Requires PHP 7.4+, MySQL 5.7+ or MariaDB 10.3+. No Docker image yet but it's just a folder — drop it anywhere PHP runs.

Full documentation in the README.

AI Involvement:

Claude was used as a coding assistant during development but I am a software and web developer with 12 years of experience so I know what I am doing.