NocoDB

Open-source Airtable alternative that turns databases into collaborative spreadsheets.

Accessing the Web Interface

  • Open a browser and go to: http://<server-ip>:8080
  • Accept the self-signed SSL certificate warning.
  • On the first visit, you’ll be prompted to create an admin account (email + password).

File and Directory Structure

  • Base install directory: /root/nocodb/
  • Docker Compose definition: /root/nocodb/docker-compose.yml
  • Environment variables: /root/nocodb/.env
  • PostgreSQL database data (persistent): /var/lib/docker/volumes/nocodb_db_data/_data
  • NocoDB internal data (uploads, configs): /var/lib/docker/volumes/nocodb_nc_data/_data
  • Nginx site config: /etc/nginx/sites-available/nocodb.conf
  • Self-signed SSL certs: /etc/nginx/ssl/
  • Nginx logs: /var/log/nginx/

Managing the Deployment

cd /root/nocodb
docker compose ps                 # View running services
docker compose logs -f            # Watch logs
docker compose down               # Stop services
docker compose up -d              # Start services

Notes

  • Nginx automatically redirects HTTP to HTTPS, serves NocoDB securely with a self-signed certificate, and proxies traffic to port 8080.
  • In Team & SettingsUsers Settings, enable “Allow signup only using invite URL” to improve security.

 

Application Details