Postgres
Overview
Connect Superblocks to Postgres to build apps with read and write access to a Postgres database:
- Read data from a Postgres database and utilize it in API steps or UI components
- Save information retrieved by other API steps or UI components by writing data to a database
Setting up Postgres
1. Select Postgres from the integrations page
2. Fill out the form with the following configuration:
- Display Name - Name that will be displayed to users when selecting this integration in Superblocks
- Host - Hostname or IP address to connect to
- Port - Port to use when connecting to PostgreSQL
- Database Name - Name of database to connect to
- Database Username - Username to use to connect
- Database Password - Password for database username
- Enable SSL - Connect via SSL if selected
- Use a self-signed SSL certificate - Use a self-signed SSL certificate if selected, for example when connecting to Cloud SQL
3. Click "Create Integration"
info
If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent)
4. Set environments
After creating the integration, you can optionally set different connection settings for your Production and Staging environments. Be sure to click Test Connection
for each environment.
success
Postgres Connected You can now write SQL to read from and write to Postgres in any Application, Workflow, or Scheduled Job.
Creating Postgres steps
Connect to your Postgres integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks Postgres integration with read only, read/write, or write only users. You can then configure a Superblocks Postgres step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the Postgres step. Then click "Run" to see the Result and Executed SQL statement below.
info
See a tutorial on how to use inline editing for bulk updating and a basic CRUD guide
Use cases
Applications
Create an admin dashboard that reads from Postgres and other sources. Mix in APIs to allow support agents to refund orders, update shipping statuses, or transform large datasets in a single UI.
Workflows
Enrich customer order data within Postgres with shipping data from Snowflake or other datastores.
Scheduled Jobs
Copy data from Postgres to a Google Sheet on a daily basis for teams who need to see info on new bookings, but don't have access to the database.
Troubleshooting
Check out our guide on common errors across database integrations, in addition to common Postgres connection issues. If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at help@superblockshq.com.