---
title: "Select"
description: "Local-first visual environment for building and running AI workflows. Build agents visually, deploy anywhere, privacy by design."
canonical: https://docs.nodetool.ai/nodes/lib/supabase/select
markdown: https://docs.nodetool.ai/nodes/lib/supabase/select.md
product: NodeTool
source: https://github.com/nodetool-ai/nodetool/blob/main/docs/nodes/lib/supabase/select.md
---

# Select

**Type:** `lib.supabase.Select`

**Namespace:** `lib.supabase`

## Description

Query records from a Supabase table.
    supabase, database, query, select

## Properties

| Property | Type | Description | Default |
|----------|------|-------------|---------|
| table_name | `str` | Table to query | `` |
| columns | `record_type` | Columns to select | `{"type":"record_type","columns":[]}` |
| filters | `list[tuple[str, enum, any]]` | List of typed filters to apply | `[]` |
| order_by | `str` | Column to order by | `` |
| descending | `bool` | Order direction | `false` |
| limit | `int` | Max rows to return (0 = no limit) | `0` |
| to_dataframe | `bool` | Return a DataframeRef instead of list of dicts | `false` |

## Outputs

| Output | Type | Description |
|--------|------|-------------|
| output | `any` |  |

## Related Nodes

Browse other nodes in the [lib.supabase](./) namespace.