pipefy-database-tables
/pipefy-database-tables
Obsługuje tabele bazy danych Pipefy: tworzenie, odczyt, aktualizację i usuwanie tabel, rekordów (wierszy) oraz pól tabeli (kolumn schematu).
- Autor
- pipefy ↗
- Repozytorium
- ai-toolkit ↗
- Licencja
- Apache-2.0
- Ostatnia zmiana repozytorium
- 26.10.2026
Ocena i bezpieczeństwo
- Pliki w paczce
- 3
- Skrypty
- 0
- Komentarze HTML
- 0
- Adresy URL w SKILL.md
- 0
Brak sygnałów. Repozytorium zmienione 26.10.2026, bez odwołań do wycofanych modeli i API.
Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.
Co robi i kiedy
Obsługuje tabele bazy danych Pipefy: tworzenie, odczyt, aktualizację i usuwanie tabel, rekordów (wierszy) oraz pól tabeli (kolumn schematu).
Oryginalny opis (EN)
Use this skill when the user wants to work with Pipefy Database Tables — creating/reading/updating/deleting tables, records (rows), or table fields (schema columns).
Jak działa
- Cross-cutting patterns
- Table operations
- Table field (schema column) operations
- Record operations
- Steps — find and update a record
- Review destructive changes
- Success criteria
- Failure modes
- See also
Podgląd SKILL.md
---
name: pipefy-database-tables
description: >
Use this skill when the user wants to work with Pipefy Database Tables —
creating/reading/updating/deleting tables, records (rows), or table fields
(schema columns).
tags: [pipefy, database, tables, records, fields]
---
# Database Tables
MCP clients: read [references/mcp.md](references/mcp.md). CLI users: read [references/cli.md](references/cli.md). Examples below describe shared operation arguments.
Tables, records (rows), schema columns (table fields), and attachments for Pipefy Database Tables.
---
## Cross-cutting patterns
- Use `introspect_type` on inputs such as `CreateTableFieldInput` / `UpdateTableFieldInput`.
- **Pagination:** `get_table_records` and `find_records` support `first` / `after`; default page size is 50.
- **`find_records` over paginated `get_table_records`** when you know the field value. One call with `field_id` and `field_value` beats N pages of `get_table_records`.
---
## Table operations
| Operation | Read-only | Purpose |
| ------------ | ----------- | --------- |
| `get_tables` | Yes | Load database tables by their IDs. |
| `search_tables` | Yes | Search tables by name. |
| `get_table` | Yes | Table metadata and field schema. |
| `create_table` | No | Create a new database table. |
| `update_table` | No | Rename or change settings. |
| `delete_table` | No | **Destructive; review and approve first.** |
---
## Table field (schema column) operations
| Operation | Purpose |
| ------------ | --------- |
| `create_table_field` | Add a column to a table schema. |
| `update_table_field` | Rename or change column description, required status, or options. |
| `delete_table_field` | **Destructive; review and approve first.** Requires `table_id`. |
---
## Record operations
| Operation | Read-only | Purpose |
| ------------ | ----------- | --------- |
| `get_table_records` | Yes | Paginated list of all records in a table. |
| `find_records` | Yes | Filter records by `field_id` and `field_value` — preferred over paginating `get_table_records`. |
| `get_table_record` | Yes | Single record with all populated field values. |
| `create_table_record` | No | Add a row to a table. |
| `update_table_record` | No | Update a row's `title`, `due_date` or `status_id`. Any other key is dropped without an error. |
| `set_table_record_field_value` | No | Set one field value on a row. Use it for every table field. |
| `delete_table_record` | No | **Destructive; review and approve first.** |
---
## Steps — find and update a record
1. **Get table ID** (if not known):
Operation: `search_tables(table_name="Customers")` and select the table ID from the results.
2. **Find the record** (use `find_records`, not pagination):
Operation: `find_records(table_id=456, field_id="email", field_value="user@example.com")`
3. **Update one field** (targeted):
Operation: `set_table_record_field_value(record_id=789, field_id="status", value="Active")`
**Update record metadata** (such as title, due date, or status):
Operation: `update_table_record(record_id=789, fields={"title":"Updated title"})`
---
## Review destructive changes
Before deletion, show the affected data and obtain explicit approval. Preview content per operation:
- **`delete_table`** — show table **name** and **field count**. `get_table` does not return a record count; obtain one through schema-checked GraphQL or by paging through all records if practical. State clearly when the count is unknown. Deleting a table destroys all rows and schema.
- **`delete_table_record`** — show record **title** and **key field values** so the user can identify which row will vanish.
- **`delete_table_field`** — show field **name** and **type**; warn explicitly that **all column data will be permanently lost**.
Never delete without first reviewing the affected data.
---
## Success criteria
- `get_table_records` returns the created/updated records with correct field values.
- Schema changes reflect immediately in `get_table`.
## Failure modes
- **`get_table_record` / `get_table_records` omit empty fields.** Records only return populated fields, so you cannot tell "field unset" from "field doesn't exist" without calling `get_table` for the full schema.
- **`create_table_record` title silently overridden.** When the first table field is a start-form-style label column, Pipefy uses that field's value as the record `title`, ignoring the `title` parameter. Don't rely on `title` if the first field auto-populates a label-like column.
- **`create_table_field` rejects type:** call `introspect_type(type_name="CreateTableFieldInput")` for valid field types.
- **`update_table_record` ignores a custom field without an error:** it sends only `title`, `due_date` and `status_id`, and drops every other key. It fails only when none of the three is present. Set each custom field with `set_table_record_field_value`, then read the record back with `get_table_record`.
- **`find_records` returns empty:** check that `field_id` matches a field's **ID** (not label) from `get_table`.
- **Pagination cursor expired:** re-fetch from the beginning; cursors are short-lived.
## See also
- `pipefy-relations` — connect tables to pipes (and the table-relation ID namespace gotcha).
- `pipefy-introspection` — discover field input schemas.
Pliki w paczce (3)
- SKILL.md 5 KB
- references/cli.md 2 KB
- references/mcp.md 1 KB
Wersje
W bazie nie ma innych skilli o nazwie pipefy-database-tables.
Migawka bazy z 13.11.2026 · wersja paczki 1bb776458f41 (skrót SHA-256 całej paczki)
Pobrania w ostatnich 30 dniach: 0 · ranking
Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.
Podobne skille
- 100pipefy-relations
Łączy pipes, tabele i karty między przepływami pracy w Pipefy, tworząc relacje pipe, tabel i kart oraz zarządzając nimi. - 90pipefy-toolkit-setup
Prowadzi przez pierwszą konfigurację zestawu narzędzi AI Pipefy: wtyczkę, zdalny serwer MCP lub lokalną instalację. - 87data-inspect
Pokazuje schemat aktywnego zbioru danych: tabele, kolumny, liczbę wierszy i relacje, a w razie potrzeby szczegóły jednej tabeli. - 100manage-tables
Tworzy tabele Tulip, wyszukuje w nich i zarządza rekordami: dodawanie, zmiana i usuwanie rekordów, agregacje, zapytania do tabel i łączenie tabel. - 100data-inspect
Pokazuje schemat aktywnego zbioru danych: tabele, kolumny, liczby wierszy i relacje, także dla wskazanej tabeli. - 90baserow
Integruje się z API Baserow przez zarządzany klucz API: odczyt, tworzenie, aktualizacja i usuwanie wierszy bazy danych oraz zapytania z filtrami.