Thin Backend

Instant Postgres Backend for your Single Page Apps

Open issues
Closed issues
Last commit
about 1 year ago
Total releases
Total commits
Open PRs
Closed PRs
Repo URL
Project Website
Offers premium version?

Thin Backend

Instant API for your Postgres DB ยป

Thin Backend is a blazing fast, universal web app backend for making realtime single page apps.

Instead of manually writing REST API endpoints or GraphQL resolvers, use a Thin Backend server to automatically get a fully featured API backend on top of your Postgres DB. Thin exposes high level functions to create, read, update and delete database record.

Code Examples

This example shows a simple CRUD example for building a Todo app with Thin:

import { useQuery, query, createRecord, updateRecord, deleteRecord, Task } from 'ihp-backend';

function Tasks() { // useQuery automatically triggers a re-render on new data const tasks = useQuery(query('tasks').orderBy('createdAt'));

return <div>
    { => <Task task={task} key={} />)}


interface TaskProps { task: Task; // <- The Task type is provided by Thin, auto-generated from the database schema } function Task({ task }: TaskProps) { const handleEdit = () => { const patch = { title: window.prompt('New Title:') || task.title };

    // `updateRecord` already updates the UI state (e.g. the &lt;Tasks /&gt; component above)
    // even before the server completed the operation.
    updateRecord('tasks',, patch);

const handleDelete = () =&gt; {
    // `deleteRecord` already hides the record from the UI state
    // even before the server completed the operation.

return &lt;div onDoubleClick={handleEdit}&gt;

    &lt;button onClick={handleDelete}&gt;delete&lt;/button&gt;


function AddTaskButton() { const handleClick = () => { const task = { title: window.prompt('Title:') };

    // `createRecord` already shows the new task in the UI
    // even before the server completed the operation.
    createRecord('tasks', task);

return &lt;button onClick={handleClick}&gt;Add Task&lt;/button&gt;


function App() { // No need for redux or other state management libs // useQuery automatically triggers a re-render on new data return <div> <Tasks /> <AddTaskButton /> </div> }

Try on Vercel

Top-notch Autocompletion

The TypeScript definitions not only provide safety, they also provide really nice autocompletion.

Feature Overview

  • Blazing Fast, Low Latency: Delight your end-users with superior speed and lowest latency. With built-in Optimistic Updates your app doesn't need to wait for the server to respond back until the changes are visible on the screen.

  • Realtime: Provide a delightful experience to your end users: With Thin Backend Live Queries your app state is synchronized in real-time across all users.

    function Tasks() {
        // `useQuery` always returns the latest database state
        // The component automatically re-renders when a record is inserted,
        // updated, or deleted in the `tasks` table
        const tasks = useQuery(query('tasks').orderBy('createdAt'));
        return <div>...</div>
  • Zero-setup Login: To get your started quickly every Thin Backend project comes with zero-setup login, user management and permissions system included.

    Already have an existing login system? No problem, you can disable the built-in login and provide Thin Backend with a JWT.

  • Secure Authorization: Thin Backend uses Postgres Policies to make sure that users can only see what they're allowed to see.

    Based on naming conventions Thin Backend will automatically generate the initial policies for you. You then only need to adjust the default policies based on your needs.

  • Powerful Schema Designer: Thin Backend has a built-in GUI-based schema designer. The schema designer helps to quickly build the DDL statements for your database schema without remembering all the PostgreSQL syntax and data types.

    But keep in mind: The schema designer is just a GUI tool to edit the underlying SQL statements. The schema designer parses the SQL statements, applies changes to the syntax tree, and then writes it back.

    Rather work with your keyboard? You can always skip the GUI and go straight to the code editor. If you need to do something advanced which is not supported by the GUI, just manually do it with your code editor of choice.

  • Git-like Migrations: Whenever you add or change a table in the Schema Designer, the changes will only be applied to the in-memory schema. The actual postgres database will only be touched when you run migrations.

    You can think of this like in a git workflow: In git changes are only applied to the repository history when you do a git commit. In Thin Backend this git commit is running a database migration.

  • Proven Architecture:

    Thin Backend is designed by the company that makes IHP, Haskell's most successful web framework. Thin Backend is built on top of the production-proven IHP architecture & libraries.

    IHP was recognized as a High Performer in G2's Winter 2022 Web Framework Report:

  • Transactions:

    You can use withTransaction to run a set of operations within a database transaction. If an exception is thrown within the transaction callback, the transaction will automatically be rolled back and the exception is re-thrown. If the callback executes successfully, the transaction will automatically be committed:

    import { withTransaction } from 'thin-backend';
    await withTransaction(async transaction => {
        const team = await transaction.createRecord('teams', { title: 'New Team' });
        const project = await transaction.createRecord('projects', {
            title: 'Project 1',
        return [ team, project ];

    Learn more in the Docs

  • Batch Operations:

    You can use createRecords, updateRecords and deleteRecords to effiently run operations on a large set of database records:

    // Example:
    const todoA = { title: 'Finish Guide', userId: '49946f4d-8a2e-4f18-a399-58e3296ecff5' };
    const todoB = { title: 'Learn Haskell', userId: '49946f4d-8a2e-4f18-a399-58e3296ecff5' };
    const todos = await createRecord('todos', [ todoA, todoB ]);

    Learn more about Batch Operations in the Docs


You can find extensive documentation on the Thin Backend website.

Getting Started

Learn how to get started in the Getting Started Guide

You can also self-host Thin Backend.

Example Apps

You can find some example apps here:


Questions, or need help? Join our Thin Community


We are happy to merge your pull requests!๐Ÿ˜„

See for more info.

Alternative Projects

Subscribe to Open Source Businees Newsletter

Twice a month we will interview people behind open source businesses. We will talk about how they are building a business on top of open source projects.

We'll never share your email with anyone else.