Ask AI

Softr Databases Overview

Store your application data in Softr Databases.

Softr Databases is relational database tool you can use to store, manage, and organize your data. You can use it as a standalone database tool, or connect it directly to your apps to show content, update records, or personalize what users see.

Think of it like a smarter spreadsheet—but built for apps.

Softr gives you a few easy ways to get started with your database:

  • Start from scratch: Set up your own tables and fields based on what your app needs.
  • Use a template: Pick from ready-made templates (like CRM, job board, or inventory) to get started faster.
  • Import: Bring your existing data into Softr with a simple import. Currently supporting CSV import, with Airtable import is coming soon.
/icons/info-alternate_lightgray.svg

Softr Databases are available on all Softr plans with some record limits. For details, check out the Pricing Page.

Step-by-Step: Create your first database

Here’s how to create your first database and understand the key pieces along the way:

Step 1: Create a new database and your first table

Go to the Databases section on the left nav of your Softr workspace and create a new database. A table is like a list of similar items. For example, if you’re building a job board, you might have a table called Jobs. If it’s a client portal, you might create a table called Clients.

Notion image

Step 2: Add Fields

Fields are the pieces of information you want to store about each item. These are the columns in your table. For example, a client might have:

  • Name
  • Email
  • Company
  • Status

Each field has a type that tells the database what kind of info it should expect. Here are a few common ones:

  • Text – for names or notes
  • Number – for prices or quantities
  • Date – for deadlines or schedules
  • File/Image – for uploading documents or pictures
  • Relationship – to connect one table to another, like linking a project to a client

Choosing the right type keeps your data organised and easy to use. Learn more about different Field types here.

Notion image

Step 3: Add Records

Each item in the list is called a record. So in your Clients table, every client is a new record—just like a row in a spreadsheet. You can fill in your data manually or enable your users to fill in the fields via the Softr application.

Notion image

Step 4: Add More Tables/Fields/Records as Needed

As your app grows, you may add more tables—such as Projects, Orders, or Support Tickets—or add more fields to collect new data, like Notes, Payment Status, and Company contacts.

That’s it—you’ve just built the foundation of your app with a well-structured database!

Connect the Database to the Softr Application

Once you've created your database, you’re ready to build and connect to your app.

Step 1: Connect your data to a dynamic block

To display your data in the app, connect a dynamic block (e.g., List, Grid, Table) to Softr Databases:

  1. Go to the Block source tab and select Softr Databases
  1. Pick the Database you want to use.
  1. Select the Table containing the records you want to display.
    1. Notion image
 
/icons/warning_gray.svg

Important: Each Database table can only connect to one Softr block. For example, if you want to display Projects in a List block, you’ll need to map it to the Projects table in your base. If you also want to show Tasks, you’ll need to add a separate block and connect it to the Tasks table.

/icons/warning_gray.svg

Note: Softr Database is compatible with the latest dynamic blocks. Inbox and Kanban don’t yet support Softr Databases. Support for these is coming soon.

Step 2: Map Database fields to item fields

When you connect your table to a block, you can choose which columns to display and map to block fields.. This lets you control how your data appears in the app.

Example: If you have a Profile Picture (Attachment field) in your Database, map it to an Image field in the Softr app so it displays correctly.

Fields in Softr Database
Fields in Softr Database
Same fields mapped to the list block
Same fields mapped to the list block
/icons/warning_gray.svg

Database fields work like spreadsheet columns, but each has a specific type (e.g., text, image, checkbox). To keep everything working smoothly, make sure to match field types correctly when setting up the connection.

3. Supported field types

All Database fields are supported in Softr Blocks. Some fields are read-only. For more detailed information about fields and their configuration, refer to the Fields page.


FAQ

Where is the Softr Database stored?

All Softr Database data is currently stored in the AWS EU Region.

Is Softr Databases GDPR compliant?

Yes, Softr follows GDPR-aligned practices for data protection and privacy.

Are Softr Databases available on the free plan?

Yes! Softr Databases are available for everyone to try, with record limits tailored to each plan so you can build and scale with confidence. The free plan includes up to 1000 records per database (and 5000 records across databases).

Can I add data to Softr Databases via API or automation tools?

A REST API, along with a Zapier and Make integration, is on the way soon to give you more flexibility to connect Softr Databases with your external data, automations, workflows, and AI agents.

 
 
 
 
Did this answer your question?
😞
😐
🤩

Last updated on June 17, 2025