Testing Your Database

To ensure that queries return the expected data, RLS policies are correctly applied and etc., we encourage you to write automated tests. There are essentially two approaches to testing:

• Firstly, you can write tests that interface with a Supabase client instance (same way you use Supabase client in your application code) in the programming language(s) you use in your application and using your favorite testing framework.

• Secondly, you can test through the Supabase CLI, which is a more low-level approach where you write tests in SQL.

Testing using the Supabase CLI

You can use the Supabase CLI to test your database. The minimum required version of the CLI is v1.11.4. To get started:

• Install the Supabase CLI on your local machine

Creating a test#

Create a tests folder inside the supabase folder:

Create a new file with the .sql extension which will contain the test.

Writing tests#

All sql files use pgTAP as the test runner.

Let's write a simple test to check that our auth.users table has an ID column. Open hello_world.test.sql and add the following code:

Running tests#

To run the test, you can use:

This will produce the following output:

More resources#

• Testing RLS policies
• pgTAP extension
• Official pgTAP documentation