---
title: "supabase-test-db"
description: "Executes pgTAP tests against the local database."
type: skill
canonical_url: https://claudary.paisolsolutions.com/skills/db
source: "Claudary"
difficulty: intermediate
author: "Claude Code Knowledge Pack"
date: 2026-07-10T11:19:36.460Z
license: CC-BY-4.0
attribution: "supabase-test-db — Claudary (https://claudary.paisolsolutions.com/skills/db)"
---

# supabase-test-db
Executes pgTAP tests against the local database.

## Overview

# supabase-test-db

Executes pgTAP tests against the local database.

Requires the local development stack to be started by running `supabase start`.

Runs `pg_prove` in a container with unit test files volume mounted from `supabase/tests` directory. The test file can be suffixed by either `.sql` or `.pg` extension.

Since each test is wrapped in its own transaction, it will be individually rolled back regardless of success or failure.

---

Source: [Claudary](https://claudary.paisolsolutions.com/skills/db) · https://claudary.paisolsolutions.com