---
title: "db-role-connections"
description: "This command shows the number of active connections for each database roles to see which specific role might be consuming more connections than expected."
type: skill
canonical_url: https://claudary.paisolsolutions.com/skills/db-role-connections
source: "Claudary"
difficulty: intermediate
author: "Claude Code Knowledge Pack"
date: 2026-07-10T11:19:36.460Z
license: CC-BY-4.0
attribution: "db-role-connections — Claudary (https://claudary.paisolsolutions.com/skills/db-role-connections)"
---

# db-role-connections
This command shows the number of active connections for each database roles to see which specific role might be consuming more connections than expected.

## Overview

# db-role-connections

This command shows the number of active connections for each database roles to see which specific role might be consuming more connections than expected.

This is a Supabase specific command. You can see this breakdown on the dashboard as well:
https://app.supabase.com/project/_/database/roles

The maximum number of active connections depends [on your instance size](https://supabase.com/docs/guides/platform/compute-add-ons). You can [manually overwrite](https://supabase.com/docs/guides/platform/performance#allowing-higher-number-of-connections) the allowed number of connection but it is not advised.

```


            ROLE NAME         │ ACTIVE CONNCTION
  ────────────────────────────┼───────────────────
    authenticator             │                5
    postgres                  │                5
    supabase_admin            │                1
    pgbouncer                 │                1
    anon                      │                0
    authenticated             │                0
    service_role              │                0
    dashboard_user            │                0
    supabase_auth_admin       │                0
    supabase_storage_admin    │                0
    supabase_functions_admin  │                0
    pgsodium_keyholder        │                0
    pg_read_all_data          │                0
    pg_write_all_data         │                0
    pg_monitor                │                0

Active connections 12/90

```

---

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