NocoDB: Turn PostgreSQL into Airtable in 1 Day
We integrate NocoDB with your relational database — PostgreSQL, MySQL, or SQLite. It’s an open-source platform that provides an Airtable-like interface without writing a single line of code. The key difference from Baserow or SeaTable: NocoDB connects to your existing database and displays real tables, not creating separate storage. Your production data stays put, and non-technical employees get a convenient spreadsheet to work with.
Over the years, we've set up NocoDB for dozens of projects: from a CRM for a sales department to a logistics monitoring dashboard. Our experience shows that 80% of internal tasks can be covered without writing code — just configure permissions correctly, create forms, and connect webhook notifications.
How NocoDB Solves the Problem of Custom Admin Panels
Custom panels built on Laravel or Django require months of development and constant maintenance. NocoDB provides a ready interface in one day, and through REST/GraphQL API you can extend functionality when truly needed. Compare: the average cost of a custom admin panel starts from $4,000 and takes 2 months. NocoDB costs a fraction — you pay only for setup and integration. Below is a comparison:
| Criteria | NocoDB | Custom Admin Panel |
|---|---|---|
| Time to launch | 1-2 days | 1-3 months |
| Cost | Setup + hosting (low) | Development + maintenance (high) |
| Data control | Full (your DB) | Full |
| API flexibility | REST/Swagger, GraphQL | Depends on implementation |
| Updates | Automatic (upstream) | Manual |
Why Choose NocoDB for Internal Tools?
The main reason is speed and security. You don’t write code but control data. NocoDB allows rapid prototyping of interfaces, then expansion via API. For example, one logistics client replaced three Excel sheets with a single dashboard in 2 days — saving 15 hours per week.
Setting up Access Permissions: Detailed Breakdown
After connecting to the DB, configuring permissions is critical. We use two levels: at the NocoDB level (table roles) and at the DBMS level (database users). For most tables, we create a separate read-only user:
-- Read-only for most tables GRANT SELECT ON ALL TABLES IN SCHEMA public TO nocodb_readonly; -- Allow editing only for specific tables GRANT SELECT, INSERT, UPDATE ON customer_notes TO nocodb_rw; GRANT SELECT, UPDATE ON users TO nocodb_rw; Example of typical permission configuration
- Reference tables (cities, statuses) — SELECT only for all
- Orders tables — SELECT + INSERT for operators, UPDATE for seniors
- Log tables — SELECT only for analysts
- Administrators — full access to selected tables
This ensures accidental modifications do not affect critical data.
REST API: Auto-Generated Endpoints
After connecting, each table gets its own API. Swagger documentation is available. Example requests:
# List records with filter GET /api/v1/db/data/noco/{PROJECT_ID}/{TABLE_ID}?where=(status,eq,active)&limit=25&offset=0 # Create record POST /api/v1/db/data/noco/{PROJECT_ID}/{TABLE_ID} {"name": "John", "email": "[email protected]", "status": "new"} # Bulk update PATCH /api/v1/db/data/bulk/noco/{PROJECT_ID}/{TABLE_ID} [{"id": 1, "status": "processed"}, {"id": 2, "status": "processed"}] The API supports all CRUD operations, filtering, sorting, and pagination. This allows integrating NocoDB with any external service or creating custom React/Vue interfaces.
No-Code Data Collection Forms
A public form from any table is a killer feature. An employee sends a link to clients, data goes directly into the DB. Use cases:
- Client requests → leads table
- Employee reports → daily logs
- Feedback collection → feedback table
Forms are configured in a few clicks: select fields, mark required, customize design. No code needed.
What Are Webhooks and How to Set Them Up?
A webhook automatically notifies an external service when data changes. In NocoDB, this takes 5 steps:
- Go to table settings → Webhooks → Add New.
- Choose event (after insert / after update / after delete).
- Enter the URL of your server.
- Configure headers (e.g., secret token for verification).
- Save. Now each change triggers a POST request with data.
Example handler in Node.js:
app.post('/hooks/nocodb/leads', async (req, res) => { const { type, data } = req.body; if (type === 'records.after.insert') { const lead = data.insertedRows[0]; // Create contact in CRM await crmApi.createContact({ email: lead.Email, name: lead.Name, phone: lead.Phone }); // Notify manager in Telegram await telegramBot.sendMessage(MANAGER_CHAT_ID, `New lead from ${lead.Name} (${lead.Email})` ); } res.sendStatus(200); }); Webhook triggers on insert, update, or delete. We've set up chains: new lead → contact in CRM + manager notification + task in Trello. All works without human intervention.
What's Included in the Work
- Connecting NocoDB to your existing database (PostgreSQL/MySQL)
- Configuring access permissions: read-only for tables, editing for selected ones
- Developing data collection forms
- Creating REST/GraphQL API and webhook integrations
- Operational documentation and employee training
- Guarantee of correct operation for 30 days after handover
Our team has years of experience in business automation (over 50 projects). Engineers are certified in AWS and PostgreSQL.
Timeline and How to Start
Connecting to an existing database + permissions + first interfaces — 1-2 days. If integration with CRM, Telegram, or other services is needed — up to a week. Exact timelines are calculated after analyzing your DB and interviewing the team.
Want a consultation? Contact us — we'll evaluate the project for free and offer an optimal solution. Order NocoDB setup today and get a ready internal tool without extra costs.