NocoDB

Key Features

• Visual database schema designer with drag-and-drop table creation and relationship management
• Multiple view types including grid, gallery, form, and kanban views for different data visualization needs
• Automatic REST API generation with authentication and role-based access control
• Real-time collaboration with user permissions, comments, and activity tracking
• PostgreSQL backend providing ACID compliance, full-text search, and advanced indexing capabilities
• Form builder for external data collection with customizable fields and validation rules
• Database import functionality supporting CSV, Excel, and direct database connections
• Webhook integrations and automation triggers for connecting with external services

Common Use Cases

• 1Customer relationship management (CRM) systems for small to medium businesses
• 2Project management and task tracking with team collaboration features
• 3Content management for blogs, documentation, and marketing materials
• 4Inventory management and product catalog administration
• 5Event planning and attendee management with form-based registration
• 6Data collection and survey management with public form interfaces
• 7Personal knowledge bases and information organization systems

Prerequisites

• Docker and Docker Compose installed on the host system
• Minimum 2GB RAM available for PostgreSQL and NocoDB containers
• Port 8080 available for NocoDB web interface access
• Basic understanding of environment variables for database password configuration
• Sufficient disk space for PostgreSQL data volume (recommend 10GB minimum)
• Network connectivity for initial container image downloads

docker-compose.yml

1services: 
2  nocodb: 
3    image: nocodb/nocodb:latest
4    container_name: nocodb
5    restart: unless-stopped
6    environment: 
7      NC_DB: "pg://postgres:5432?u=nocodb&p=${DB_PASSWORD}&d=nocodb"
8    ports: 
9      - "8080:8080"
10    depends_on: 
11      - postgres
12    networks: 
13      - nocodb
14
15  postgres: 
16    image: postgres:15-alpine
17    container_name: nocodb-postgres
18    restart: unless-stopped
19    environment: 
20      POSTGRES_USER: nocodb
21      POSTGRES_PASSWORD: ${DB_PASSWORD}
22      POSTGRES_DB: nocodb
23    volumes: 
24      - postgres_data:/var/lib/postgresql/data
25    networks: 
26      - nocodb
27
28volumes: 
29  postgres_data: 
30
31networks: 
32  nocodb: 
33    driver: bridge

.env Template

1DB_PASSWORD=changeme

Usage Notes

Individual Services(2 services)

Copy individual services to mix and match with your existing compose files.

nocodb:
  image: nocodb/nocodb:latest
  container_name: nocodb
  restart: unless-stopped
  environment:
    NC_DB: pg://postgres:5432?u=nocodb&p=${DB_PASSWORD}&d=nocodb
  ports:
    - "8080:8080"
  depends_on:
    - postgres
  networks:
    - nocodb

postgres:
  image: postgres:15-alpine
  container_name: nocodb-postgres
  restart: unless-stopped
  environment:
    POSTGRES_USER: nocodb
    POSTGRES_PASSWORD: ${DB_PASSWORD}
    POSTGRES_DB: nocodb
  volumes:
    - postgres_data:/var/lib/postgresql/data
  networks:
    - nocodb

Quick Start

1# 1. Create the compose file
2cat > docker-compose.yml << 'EOF'
3services:
4  nocodb:
5    image: nocodb/nocodb:latest
6    container_name: nocodb
7    restart: unless-stopped
8    environment:
9      NC_DB: "pg://postgres:5432?u=nocodb&p=${DB_PASSWORD}&d=nocodb"
10    ports:
11      - "8080:8080"
12    depends_on:
13      - postgres
14    networks:
15      - nocodb
16
17  postgres:
18    image: postgres:15-alpine
19    container_name: nocodb-postgres
20    restart: unless-stopped
21    environment:
22      POSTGRES_USER: nocodb
23      POSTGRES_PASSWORD: ${DB_PASSWORD}
24      POSTGRES_DB: nocodb
25    volumes:
26      - postgres_data:/var/lib/postgresql/data
27    networks:
28      - nocodb
29
30volumes:
31  postgres_data:
32
33networks:
34  nocodb:
35    driver: bridge
36EOF
37
38# 2. Create the .env file
39cat > .env << 'EOF'
40DB_PASSWORD=changeme
41EOF
42
43# 3. Start the services
44docker compose up -d
45
46# 4. View logs
47docker compose logs -f

One-Liner

Run this command to download and set up the recipe in one step:

1curl -fsSL https://docker.recipes/api/recipes/nocodb/run | bash

Troubleshooting