Help

Ran into trouble? Here are some answers that might help. If not, you can always visit our cozy Discord server or reach me at sk@dashibase.com!

How do I add a data source?

Dashibase currently supports adding any PostgreSQL database as a data source.

To connect a database:

  1. Click on Data Sources in the sidebar.
  2. Click on Connect data source on the top right of the screen.
  3. Under General, enter a name for your data source.
  4. Under Postgres Credentials, enter your database credentials:
    • Host
    • Database name
    • Port
    • Username
    • Password
  5. Click on Set access.
Screenshot showing database credentials on Supabase

Note: Certain database providers (e.g. AWS, Azure, Google Cloud) block incoming connections by default. If you're using one of these providers, you'll need to whitelist our IP address: 52.201.72.191/32

Please refer to the following articles for instructions on the whitelisting process:

Where can I find my database credentials?

Supabase

  1. Navigate to your Supabase project page.
  2. Click on the Settings cog located to the left of the screen.
  3. Click on Database.
  4. Scroll down to Connection info.
Screenshot showing database credentials on Supabase

Note: User corresponds to Username.


Neon

  1. Navigate to your Neon project page.
  2. Go to Dashboard.
  3. In the Connection Details section, find your Connection string.
  4. Screenshot showing database credentials on Neon
  5. The Connection string is in the form postgres://[Username]:[Password]@[Host]:[Port]/[Database Name]. For example, the connection string above corresponds to:
    • Host: blue-smoke-925636.cloud.neon.tech
    • Database name: main
    • Port: 5432
    • Username: dashibase
    • Password: MyCoolPassword

Note: If it is not your first time opening the dashboard, the connection string will not display the password. If you forgot the associated password, you can either create a new user or reset the password.

Where can I find my Supabase Anon Key and URL?

You can find it by heading to your Supabase Project Page > Settings > API.

See below for an example of the Supabase API Settings screen.

How do I create a user column that is a foreign key to the id column of auth.users?

First, add a new column named "user" and then click on "Add foreign key relation" and select the auth.users table and its id attribute.

See video below for details.

When I try signing up to my dashboard, the signup email redirects me to http://localhost:3000.

Check that you have added your dashboard URL (https://XXX.app.dashibase.com) to the list of additional redirect URLs.

You can find the setting by navigating to Supabase > Authentication > Settings.

See below for an example of the Supabase Authentication Settings screen.

When I try to add a new item in my dashboard, I get an error that says "new row violates row-level security policy".

This is likely because you enabled Row-Level Security (RLS) for your Supabase table, but you did not set the policies explicitly.

Check out the Supabase tutorial on setting RLS policies here.

You can also set your policies by navigating to Supabase > Authentication > Policies.

My question isn't answered here.

Drop me a note at sk@dashibase.com! I'd love to be able to help you out.