The TypeScript library to build internal tools fast

Modular components to build impressive end-to-end solutions for internal tools on top of your database, with user authentication included.

Demo screenshot
Watch Ruslan build a subZero app
5 min

Building Blocks for Internal Tools

Leverage our suite of libraries for rapid development of internal tools.

Simplicity

Integrates in your existing codebase

Instead of combining multiple tools and managing complex production infrastructure, subZero integrates into your existing codebase and runs as part of your code.

Self-Configuration

Automatic database introspection

There is no need write custom code for each endpoint, just point subZero at your database and it will automatically introspect your schema and create a REST API for you.

Security

Built-in authentication & authorization

Complete user registration and authentication flows out of the box. To implement authorization you can rely on grants and policies from your database or specify them separately in a JSON file.

No Lock-In

Standardized API format

subZero's API format is compatible with PostgREST and GoTrue, so you can use the open-source client libraries and tools in your frontend code.

Adaptive UI

Automatic Interface Generation

Complete auto-generated CRUD interfaces using React-Admin, covering 80% of typical use cases. Seamless adaptation ensures no code changes when the database schema evolves. The rest is fully customizable.

Productivity

Rapid Development

The automatic creation of APIs and UIs reduces manual coding, allowing for rapid tool creation and faster project timelines.

Built for developers

Build more while worrying less. Reduce errors and boosts productivity.

Seamless Backend Integration

Unlike competing products that require your code to adapt to their framework (and lock you into their SaaS), subZero, as a library, seamlessly integrates into your existing Node, Express, or NextJs backend. It becomes an integral part of your codebase, giving you control over how your product is built.

Backend
import express from 'express';
import { getRequestHandler as auth } from '@subzerocloud/auth';
import { getRequestHandler as rest } from '@subzerocloud/rest';
//...
const app = express();
app.use('/auth', auth());
app.use('/rest', rest());
//...
app.listen(3000, () => console.log('Listening on port 3000'));

Streamlined Frontend Development

While the choice of frontend framework ultimately lies in your hands, subZero has been fine-tuned to take full advantage of React and React-Admin. This combination enables an automated, efficient, and superior frontend generation.

Frontend
import {Admin, Resource} from 'react-admin';
import {loadSchema} from '@subzerocloud/ra-subzero';
//...
useEffect(() => {  loadSchema(client).then(schema => setSchema(schema));}, []);
//...
<Admin>
  {Object.keys(schema).map(model => {
    return <Resource key={model} name={model} /* ... */ />
  })}
</Admin>

Comprehensive and Versatile Security

Secure your application with a wide array of authentication methods tailored to your needs.

Authorization
-- grant read access to the customers table for employees
grant select (id, name) on customers to employee;

-- filter customers to only those belonging to the current user
create policy 'Access to own customers'
on customers to employee
using (account_manager_id = auth.uid()) ;

Advanced Access Controls

Granularly control what users can access by leveraging your database permissions system (grants and row level security). For databases without these features, subZero provides an equivalent external configuration option.

Authentication
client.auth.signInWithPassword({
  email: 'alice@email.com',
  password: 'secret-password'
}
);
client.auth.signInWithOtp({email: 'alice@email.com'});
client.auth.signInWithOAuth({provider: 'google'});
client.auth.signInWithSSO({domain: 'company.com'});

SAML SSO, 2FA, and More

subZero offers versatile authentication with SAML SSO, 2FA, and multiple sign-in options, including Google, Okta, and traditional email/password. It supports OAuth flows and ensures high security standards for your application.

Simplify your infrastructure.

Eliminate countless services that need to be managed and maintained.

Simplicity

All you need is your database and a way to run JavaScript.

Other solutions require deploying multiple services or lock you into a specific SaaS. subZero provides all the benefits of auto-generated APIs without the hassle of managing complex backend infrastructure.

No Lock-In

You can use subZero with any database, on any platform.

By providing a clean interface consisting of pure functions, our library can be used on any platform with a JavaScript runtime and any PostgreSQL/MySql/SQLite/ClickHouse compatible database.

Zero-Dependency

Almost a full backend in just 322 kB package.

With such a small footprint, our library can be used even in the most resource-constrained environments. Now your entire backend can fit into a single Cloudflare worker which has a 1MB limit.

Easy deployment on these platforms

    • Netlify
    • Vercel
    • AWS Lambda
    • Google Cloud Functions
    • Cloudflare
    • NodeJS

Embrace AI-Powered Development

Moving Past Drag-and-Drop: Where AI and Code Editors Meet

The Limitation of Browser-Based UI Builders

While competitors offer browser-based UI builders, they often fall short in AI integration. These platforms may provide drag-and-drop simplicity, but they lack the flexibility and intelligence that AI can offer. You're confined to a set of predefined components, limiting your ability to innovate and adapt.

The subZero Difference: AI-Ready, Editor-Based

subZero takes a different route. We offer an editor/library-based approach that's designed to work seamlessly with AI tools like Copilot and ChatGPT. Instead of being confined to a browser, you can leverage the full power of your code editor, integrating AI-generated code directly into your project.

Why It Matters: Frameworks and REST Flavors

subZero is built on well-understood frameworks like Node, Express, React, and React-Admin, and it uses REST flavors compatible with PostgREST. This means AI tools, trained on vast codebases, can generate highly relevant and optimized code for your subZero project. You're not just building faster—you're building smarter.

Rapid Development, Immediate Results

With subZero, Your App Begins 50% Complete

While competitors often resort to marketing jargon, promising quick results that typically amount to a simple "Hello World" application, subZero immediately provides 50% of your application’s robust, customizable functionality. Within the first hour, as you define roles and permissions, this functionality extends to 70%.

Developing internal tools usually starts with the daunting tasks of extensive setup and overcoming the “white page” syndrome. These crucial business tools, primarily CRUD applications with added authentication, traditionally demand significant time, a team, and a hefty budget from the outset. subZero efficiently cuts through these initial challenges.

You are not just starting; you are halfway there.

Simple pricing, for everyone.

Get a lifetime license for a one-time payment. No subscriptions. No hidden fees.

Personal

For individuals working on their big ideas.

Free

  • One developer
  • Lifetime license
  • Unlimited projects
  • Unlimited free updates
  • Binary releases
  • Authentication
    Email & Password
  • Supported Databases
    PostgreSQL, MySQL, SQLite
Get started

Team

For product teams

$200

  • Up to 5 developers
  • Lifetime license
  • One project
  • 1 year of free updates
  • Binary releases
  • Authentication
    Email & Password, OTP, oAuth2
  • Supported Databases
    PostgreSQL, MySQL, SQLite



  • One-click Deployments
    Docker, Native
    Vercel, Netlify, Cloudflare
    Render, Fly.io
Contact us

Enterprise

For large scale businesses and agencies.

Custom

  • Unlimited developers
  • Lifetime license
  • Unlimited projects
  • 3 years of free updates
  • Full source code
  • Authentication
    Email & Password, OTP, oAuth2, SAML
  • Supported Databases
    PostgreSQL, MySQL, SQLite
    SQL Server, Oracle
    BigQuery, Redshift, ClickHouse, SnowFlake
  • One-click Deployments
    Docker, Native
    Vercel, Netlify, Cloudflare
    Render, Fly.io
    Kubernetes
Contact us

Begin crafting your internal tool in less than 10 minutes.

Experience the simplicity, speed, and power of subZero firsthand and redefine your development process.