Kanba now supports optional PostgreSQL as an alternative to Supabase for local development and self-hosted deployments. This guide will help you set up and use PostgreSQL with Kanba.

1. Start PostgreSQL with Docker:

   npm run postgres:start

2. Configure environment:

   cp env.example .env.local

   Edit .env.local and set:

   DATABASE_PROVIDER=postgresql
   DATABASE_URL=postgresql://postgres:password@localhost:5432/kanba_db

3. Setup database:

   npm run postgres:setup

4. Start development server:

   npm run dev

1. Install PostgreSQL:

   • macOS: brew install postgresql
   • Ubuntu/Debian: sudo apt install postgresql postgresql-contrib
   • Windows: Download from postgresql.org

2. Create database:

   createdb kanba_db

3. Configure environment:

   cp env.example .env.local

   Edit .env.local and set:

   DATABASE_PROVIDER=postgresql
   DATABASE_URL=postgresql://username:password@localhost:5432/kanba_db

4. Setup database:

   npm run postgres:setup

• Node.js 18+ and npm
• PostgreSQL 13+ (or Docker)
• Git

1. Install dependencies:

   npm install

2. Install Prisma CLI:

   npm install -g prisma

Copy env.example to .env.local and configure:

# Database Configuration
DATABASE_PROVIDER=postgresql  # or 'supabase'

# PostgreSQL Configuration
DATABASE_URL=postgresql://username:password@localhost:5432/kanba_db

# Supabase Configuration (fallback)
NEXT_PUBLIC_SUPABASE_URL=your_supabase_url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_key

# Local PostgreSQL
DATABASE_URL=postgresql://postgres:password@localhost:5432/kanba_db

# Docker PostgreSQL
DATABASE_URL=postgresql://postgres:password@localhost:5432/kanba_db

# Railway PostgreSQL
DATABASE_URL=postgresql://username:password@host:port/database

# Supabase PostgreSQL
DATABASE_URL=postgresql://postgres:[password]@[host]:[port]/postgres

Run the setup script:

npm run postgres:setup

This will:

• Generate Prisma client
• Push schema to database
• Run migrations
• Seed database (if available)

1. Generate Prisma client:

   npm run db:generate

2. Push schema to database:

   npm run db:push

3. Run migrations (if any):

   npm run db:migrate

# Start PostgreSQL
npm run postgres:start

# Stop PostgreSQL
npm run postgres:stop

# Reset PostgreSQL (delete all data)
npm run postgres:reset

# View logs
docker-compose -f docker-compose.postgres.yml logs -f

View and edit your database through a web interface:

npm run db:studio

# Generate Prisma client
npm run db:generate

# Push schema changes
npm run db:push

# Create and run migration
npm run db:migrate

# Reset database
npm run db:push --force-reset

1. Set environment variable:

   DATABASE_PROVIDER=postgresql

2. Configure PostgreSQL connection:

   DATABASE_URL=postgresql://...

3. Setup database:

   npm run postgres:setup

1. Set environment variable:

   DATABASE_PROVIDER=supabase

2. Configure Supabase:

   NEXT_PUBLIC_SUPABASE_URL=...
   NEXT_PUBLIC_SUPABASE_ANON_KEY=...

The PostgreSQL schema includes all the same tables as Supabase:

• profiles - User profiles and authentication
• projects - Kanban projects
• columns - Project columns
• tasks - Tasks within columns
• project_members - Team collaboration
• task_comments - Task comments
• activity_logs - Activity tracking
• notifications - User notifications
• bookmarks - User bookmarks
• stripe_ tables* - Stripe integration

1. "Cannot find module '@prisma/client'"

   npm install
   npm run db:generate

2. "Connection refused"

   • Check if PostgreSQL is running
   • Verify connection string
   • Check firewall settings

3. "Database does not exist"

   createdb kanba_db

4. "Permission denied"

   • Check PostgreSQL user permissions
   • Verify connection string credentials

# Using Docker
npm run postgres:reset

# Using local PostgreSQL
dropdb kanba_db
createdb kanba_db
npm run db:push

# Docker logs
docker-compose -f docker-compose.postgres.yml logs postgres

# PostgreSQL logs (local installation)
tail -f /var/log/postgresql/postgresql-*.log

1. Create Railway project
2. Add PostgreSQL service
3. Set environment variables:

   DATABASE_PROVIDER=postgresql
   DATABASE_URL=${{Postgres.DATABASE_URL}}

1. Add PostgreSQL addon
2. Set environment variables in Vercel dashboard
3. Deploy with PostgreSQL connection

1. Install PostgreSQL on server
2. Create database and user
3. Set environment variables
4. Run migrations:

   npm run db:migrate

• Prisma Documentation
• PostgreSQL Documentation
• Docker PostgreSQL

When contributing to PostgreSQL support:

1. Test with both Supabase and PostgreSQL
2. Update database adapter if needed
3. Add new database helpers for complex queries
4. Update this documentation

This PostgreSQL support follows the same license as the main Kanba project.