Version control your database schemas and data using Git semantics, directly inside PostgreSQL. No external dependencies. Just SQL.
-- Monday: Create a feature branch with real data
SELECT pggit.create_branch('feature/user-profiles');
-- Tuesday: Make changes safely
ALTER TABLE users ADD COLUMN avatar_url TEXT;
-- Wednesday: Merge back with zero conflicts
SELECT pggit.merge('feature/user-profiles', 'main');
-- Result: 'MERGE_SUCCESS' ✓All features are completely free and open source under MIT license. No premium tiers, no hidden costs.
Create isolated branches with real data. Work on features without affecting production. Copy-on-write ensures efficient storage.
Intelligent conflict resolution just like Git. Automatic merges for non-conflicting changes, clear reporting when manual review is needed.
Go back to any point in your database history. See exactly what changed, when, and by whom. Perfect for debugging and auditing.
Deploy schema changes without downtime. AI-powered migration analysis identifies potential issues before they happen.
Every change is tracked automatically. Perfect for compliance (SOX, HIPAA, GDPR). Know who changed what, when, and why.
Built as a PostgreSQL extension. No external dependencies, no learning curve. If you know SQL, you know pgGit.
Single command installation. Works with any existing PostgreSQL database.
git clone https://github.com/evoludigit/pgGit.git
cd pgGit
make && sudo make install
psql -c "CREATE EXTENSION pggit"Create branches and make changes just like with Git, but for your database.
-- Initialize pgGit
SELECT pggit.init();
-- Create a branch
SELECT pggit.create_branch('feature/new-ui');
-- Make changes
ALTER TABLE users ADD COLUMN theme VARCHAR(50);Review and merge changes with confidence. Automatic conflict detection and resolution.
-- Review changes
SELECT * FROM pggit.status();
-- Merge when ready
SELECT pggit.merge('feature/new-ui', 'main');| Feature | Traditional Tools | pgGit |
|---|---|---|
| Schema Tracking | ✅ Basic | ✅ Comprehensive |
| Database Branching | ❌ Not Available | ✅ True Git-like |
| Data Branching | ❌ Not Available | ✅ Copy-on-Write |
| Merge Conflicts | ❌ Manual | ✅ Three-way detection |
| Time Travel | ❌ Limited | ✅ Any point in time |
| Storage Efficiency | ❌ Full copies | ✅ Compressed COW |
| PostgreSQL 17 | ❌ Basic support | ✅ Native integration |
| Price | 💰 $1000s/year | ✅ Free (MIT) |
Join developers who are already using pgGit to version control their PostgreSQL databases
# Install in 2 minutes
git clone https://github.com/evoludigit/pgGit.git
cd pgGit && make && sudo make install