# ToolJet

> Open-source low-code platform for internal tools.

- Category: Development Tools
- Difficulty: intermediate
- Components: tooljet, postgres
- Tags: tooljet, lowcode, internal, builder
- Source: https://docker.recipes/development/tooljet

## Overview

ToolJet is an open-source low-code platform designed for building internal tools and business applications without extensive coding. Created to bridge the gap between no-code limitations and full development complexity, ToolJet enables teams to rapidly create dashboards, admin panels, CRUD applications, and workflow automation tools using a visual drag-and-drop interface. The platform supports over 40 data source integrations including databases, APIs, and SaaS tools, making it particularly valuable for organizations that need to consolidate data from multiple systems into unified interfaces.

This stack combines ToolJet with PostgreSQL to create a production-ready internal tool development environment. PostgreSQL serves as ToolJet's metadata store, managing application configurations, user permissions, data source connections, and component definitions, while also functioning as a primary data source for applications built within the platform. The combination leverages PostgreSQL's robust transaction support and JSON capabilities to handle ToolJet's complex application schemas and dynamic query requirements.

This configuration is ideal for development teams, IT departments, and growing companies that need to rapidly prototype and deploy internal applications. Unlike SaaS alternatives, this self-hosted setup provides complete data control, unlimited users, and the ability to integrate with internal systems behind firewalls, making it particularly valuable for organizations with strict data governance requirements or those seeking to avoid recurring subscription costs.

## Features

- Visual drag-and-drop application builder with 45+ pre-built UI components including tables, charts, forms, and custom widgets
- Native integrations with 40+ data sources including PostgreSQL, MySQL, MongoDB, REST APIs, GraphQL, Slack, and Google Sheets
- JavaScript code editor for custom business logic, data transformations, and complex workflows within low-code applications
- Multi-user workspace management with granular permissions, role-based access control, and application sharing capabilities
- Real-time collaboration features allowing multiple developers to work on applications simultaneously with version control
- Custom component marketplace and plugin system for extending functionality beyond built-in components
- PostgreSQL-backed application metadata storage with full ACID compliance for configuration integrity
- Mobile-responsive application deployment with automatic scaling for different screen sizes and devices

## Use cases

- Building internal dashboards that aggregate data from multiple databases, APIs, and third-party services into unified views
- Creating CRUD applications for managing customer data, inventory systems, and employee databases without full stack development
- Developing approval workflow systems for expense reports, leave requests, and procurement processes with automated notifications
- Prototyping data visualization tools and business intelligence reports before investing in enterprise BI solutions
- Building admin panels for managing application settings, user accounts, and system configurations across multiple services
- Creating customer support tools that integrate ticketing systems, knowledge bases, and communication channels
- Developing content management interfaces for marketing teams to update websites, campaigns, and product catalogs

## Prerequisites

- Minimum 2GB RAM and 10GB storage space for ToolJet application runtime and PostgreSQL data storage
- Docker and Docker Compose installed with support for multi-container networking and persistent volumes
- Basic understanding of SQL and database concepts for configuring data sources and building queries
- Familiarity with environment variables and secure secret management for database passwords and encryption keys
- Port 3000 available for ToolJet web interface access and understanding of reverse proxy setup for production use
- Knowledge of JavaScript fundamentals for implementing custom logic and data transformations within applications

## docker-compose.yml

```yaml
services:
  tooljet:
    image: tooljet/tooljet-ce:latest
    container_name: tooljet
    restart: unless-stopped
    environment:
      TOOLJET_HOST: http://localhost:3000
      PG_HOST: postgres
      PG_DB: tooljet
      PG_USER: tooljet
      PG_PASS: ${DB_PASSWORD}
      SECRET_KEY_BASE: ${SECRET_KEY}
      LOCKBOX_MASTER_KEY: ${LOCKBOX_KEY}
    ports:
      - "3000:3000"
    depends_on:
      - postgres
    networks:
      - tooljet

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

volumes:
  postgres_data:

networks:
  tooljet:
    driver: bridge
```

## .env

```bash
DB_PASSWORD=changeme
SECRET_KEY=generate-a-secret-key
LOCKBOX_KEY=generate-a-lockbox-key
```

## Usage notes

- Access at http://localhost:3000
- Visual app builder
- 40+ data source integrations

## Troubleshooting

- ToolJet fails to start with 'PG connection refused': Verify postgres container is running and PG_HOST environment variable matches the PostgreSQL service name in docker-compose
- Applications load slowly or timeout: Increase PostgreSQL shared_buffers and work_mem settings, or add database indexes for frequently queried ToolJet metadata tables
- Secret key errors during startup: Generate proper SECRET_KEY_BASE and LOCKBOX_MASTER_KEY values with sufficient entropy (64+ characters) and ensure they remain consistent across restarts
- Data source connections fail within ToolJet: Check that external services are reachable from the Docker network and verify firewall rules allow container-to-host communication
- User authentication issues or session timeouts: Verify TOOLJET_HOST environment variable matches the actual access URL including protocol and port number
- PostgreSQL disk space errors: Monitor postgres_data volume usage and implement log rotation or increase available storage for the Docker volume

