SQL Database
Connect your PostgreSQL, MySQL, SQL Server and MariaDB databases to Softr apps.
In Softr, you can build data-driven apps with PostgreSQL, MySQL, SQL Server, and MariaDB as data sources.
With SQL data sources, you can:
-
Show your structured data in custom apps and dashboards
-
Enable secure access for internal teams and external partners
-
Scale without hitting record limitations
1. Connect your SQL database to Softr
Before you connect, make sure you have:
-
Your SQL database credentials: host, port, database name, user, and password.
-
Permission to access the database.
Open Integrations
-
In the Softr Studio dashboard, click Integrations in the left menu.
-
Click Connect new.
- In the Select an integration window, click PostgreSQL, MySQL, SQL Server, or MariaDB.
Enter your database credentials
The connect window asks for these fields:
-
Name: A name that helps you recognize the connection in Softr.
-
Host: The database server address, for example
db.example.com. -
Port: The port your server uses. Softr fills in the default port for the database type:
5432for PostgreSQL,3306for MySQL and MariaDB, and1433for SQL Server. -
Database: The name of your database.
-
User: Your database username.
-
Password: Your database password.
Confirm your setup
Click Connect to verify and establish the connection. If the connection fails, check your credentials and try again.
2. Connect your SQL data to your Softr app
Once your SQL account is connected, you can use it in any Softr application.
Connect your data to a dynamic block
To display your data in the app, connect a dynamic block (for example, List, Grid, or Table) to your SQL table:
-
Go to the block Source tab and select your SQL account in Account.
-
Select the database you want to use.
-
For PostgreSQL and SQL Server, select the schema. MySQL and MariaDB have no schema field.
-
Select the table you want to use, or add a new query.
-
Optionally, select the primary field.
Map Fields
When you connect your table to a block, you can choose which table properties to display and map to Softr fields. This lets you control how your data appears in Softr.
Example: If you have an email field in the SQL database, select an email field in Softr.
Restricting IP Access
If needed, add Softr’s IPs to your database’s allowed list:
-
3.120.79.212 -
3.123.159.186 -
52.58.246.121
FAQs
Can I update my SQL database from Softr?
Yes! You can create forms in Softr that write data back to your SQL database.
Is my SQL data secure?
Absolutely! Softr uses industry-standard encryption to protect your data.
Can I connect multiple databases to one Softr app?
Yes! You can connect multiple SQL databases and use them within the same app.
March 7, 2025