Connect Daftra to Supabase

Both apps 110Daftra 47Supabase 63

• Trigger
  Client Created

  Triggers when a new client is added to your Daftra account.

• Trigger
  Client Updated

  Triggers when a client is added or updated in Daftra.

• Trigger
  Estimate Updated

  Triggers when an estimate (quote) is created or updated in Daftra.

• Trigger
  Invoice Created

  Triggers when a new invoice (or debit note) is created in Daftra.

• Trigger
  Invoice Updated

  Triggers when an invoice or debit note is created or updated in Daftra.

• Trigger
  Journal Created

  Triggers when a new journal entry is created in Daftra.

• Trigger
  Journal Updated

  Triggers when a journal entry is created or updated in Daftra.

• Trigger
  Product Created

  Triggers when a new product is added in Daftra.

• Trigger
  Product Updated

  Triggers when a product is added or updated in Daftra.

• Action
  Add Client

  Creates a new client in Daftra and returns its id and client number.

• Action
  Add credit note

  Creates a credit note for a client in Daftra, optionally against a source invoice, with line items.

• Action
  Add Estimate

  Creates a new estimate (quote) for a client in Daftra, with optional line items.

• Action
  Add Expense

  Creates an expense in Daftra with its amount, date, vendor, category and optional taxes, account splits and cost-center allocations.

• Action
  Add Invoice

  Creates a sales invoice for a client in Daftra, with optional line items and payments, and returns the new invoice's id.

• Action
  Add Invoice Payment

  Records a payment against an existing Daftra invoice and returns the new payment's id.

• Action
  Add Journal

  Creates a manual double-entry journal entry with its debit and credit lines. Total debits must equal total credits.

• Action
  Add Product

  Creates a new product, service or bundle in Daftra and returns its id.

• Action
  Add Refund Receipt

  Creates a refund receipt against an existing invoice in Daftra, with optional refunded line items and refund payments.

• Action
  Add Supplier

  Creates a new supplier in Daftra and returns its id.

• Action
  Delete Client

  Deletes a client from Daftra. The client must have no invoices, payments or other related records.

• Action
  Delete credit note

  Deletes a credit note in Daftra by its ID.

• Action
  Delete Estimate

  Deletes an estimate (quote) in Daftra. Estimates already converted to an invoice or sales order cannot be deleted.

• Action
  Delete Expense

  Deletes an expense in Daftra, along with its related accounting journal and attachments.

• Action
  Delete Invoice

  Deletes a sales invoice in Daftra by its ID.

• Action
  Delete Invoice Payment

  Deletes an invoice payment, re-adjusting the related invoice's paid total and the client's balance.

• Action
  Delete Product

  Deletes a product, service or bundle in Daftra by its ID.

• Action
  Delete Refund Receipt

  Deletes a refund receipt in Daftra by its ID.

• Action
  Delete Supplier

  Deletes a supplier from Daftra. Suppliers referenced by purchase orders, expenses or other transactions cannot be deleted.

• Action
  Edit Client

  Updates an existing client in Daftra. Only the fields you fill in are changed.

• Action
  Edit Estimate

  Updates an existing estimate (quote) in Daftra, changing its client, date, currency, notes or line items.

• Action
  Edit Expense

  Updates an existing expense in Daftra. Only the fields you fill in are changed.

• Action
  Edit Invoice

  Updates an existing standard invoice in Daftra, including its header details, line items, payments and custom fields.

• Action
  Edit Invoice Payment

  Updates an existing invoice payment in Daftra. Only the fields you fill in are changed.

• Action
  Edit Journal

  Updates an existing journal entry in Daftra, replacing its debit and credit lines.

• Action
  Edit Product

  Updates an existing product, service or bundle in Daftra. Only the fields you fill in are changed.

• Action
  Edit Refund Receipt

  Updates an existing refund receipt in Daftra — its date, currency, store, notes or line items.

• Action
  Edit Supplier

  Updates an existing supplier's business name, contact details, addresses and other details.

• Action
  Get client

  Returns a single Daftra client by id, with its contact details, addresses, balances and custom field values.

• Action
  Get Expense

  Returns a single expense by its id, including amount, taxes, totals, vendor, category, date and status.

• Action
  Get invoice

  Returns a single standard invoice by ID, with its line items, payments, taxes, client and custom fields.

• Action
  Get Purchase Order

  Returns a single purchase order by its ID, including its line items, supplier, taxes, payments and custom fields.

• Action
  Get Refund Receipt

  Returns a single refund receipt by ID, including its line items, payments, taxes, custom fields and client.

• Action
  List clients

  Returns a list of clients in your Daftra account, optionally filtered by keyword or assigned staff member.

• Action
  List estimates

  Returns the account's estimates (quotes), most recent first, optionally filtered by client, number, status, amount, dates and more.

• Action
  List invoices

  Returns a page of your Daftra invoices and debit notes, most recent first, optionally filtered by client, status, dates, amounts and more.

• Action
  List products

  Returns a page of products and services in your Daftra account, optionally filtered by keyword, category, supplier, brand, stock status, barcode or product code.

• Action
  Update credit note

  Updates an existing credit note in Daftra — its client, date, currency, store, notes or line items.

• Action
  Alpha Creates A New Api Key For The Project

  Creates a 'publishable' or 'secret' api key for an existing supabase project, optionally with a description; 'secret' keys can have customized jwt templates.

• Action
  Alpha Get A Third Party Integration

  Retrieves the detailed configuration for a specific third-party authentication (tpa) provider, identified by `tpa id`, within an existing supabase project specified by `ref`.

• Action
  Alpha Lists All Third Party Auth Integrations

  Lists all configured third-party authentication provider integrations for an existing supabase project (using its `ref`), suitable for read-only auditing or verifying current authentication settings.

• Action
  Alpha Removes A Third Party Auth Integration

  Removes a third-party authentication provider (e.g., google, github) from a supabase project's configuration; this immediately prevents users from logging in via that method.

• Action
  Alpha Updates An Api Key For The Project

  Updates an existing supabase project api key's `description` and/or `secret jwt template` (which defines its `role`); does not regenerate the key string.

• Action
  Beta Activates A Vanity Subdomain For A Project

  Activates a vanity subdomain for the specified supabase project, requiring subsequent dns configuration for the subdomain to become operational.

• Action
  Beta Checks Vanity Subdomain Availability

  Checks if a specific vanity subdomain is available for a supabase project; this action does not reserve or assign the subdomain.

• Action
  Beta Get Project S Ssl Enforcement Configuration

  Retrieves the ssl enforcement configuration for a specified supabase project, indicating if ssl connections are mandated for its database.

• Action
  Beta Gets Current Vanity Subdomain Config

  Fetches the current vanity subdomain configuration, including its status and custom domain name, for a supabase project identified by its reference id.

• Action
  Beta Gets Project S Network Bans

  Retrieves the list of banned ipv4 addresses for a supabase project using its unique project reference string; this is a read-only operation.

• Action
  Beta Gets Project S Network Restrictions

  Retrieves the current network restriction settings (e.g., ip whitelists) for a supabase project using its reference id; this is a read-only operation for auditing or verifying network security.

• Action
  Beta Gets Project S Pgsodium Config

  Retrieves the pgsodium configuration, including the root encryption key, for an existing supabase project identified by its `ref`.

• Action
  Beta Remove Network Bans

  Removes specified ipv4 addresses from a supabase project's network ban list, granting immediate access; ips not currently banned are ignored.

• Action
  Beta Run Sql Query

  Executes a given sql query against the project's database; use for advanced data operations or when standard api endpoints are insufficient, ensuring queries are valid postgresql and sanitized. use the get table schemas or generate type script types tool to retrieve the table schema, then base your query on it.

• Action
  Beta Updates Project S Network Restrictions

  Updates and applies network access restrictions (ipv4/ipv6 cidr lists) for a supabase project, which may terminate existing connections not matching the new rules.

• Action
  Config Pgsodium Update With Root Key Warning

  Critically updates or initializes a supabase project's pgsodium root encryption key for security setup or key rotation, requiring secure backup of the new key to prevent irreversible data loss.

• Action
  Create A Database Branch

  Creates a new, isolated database branch from an existing supabase project (identified by `ref`), useful for setting up separate environments like development or testing, which can optionally be linked to a git branch.

• Action
  Create A Function

  Creates a new serverless edge function for a supabase project (identified by `ref`), requiring valid javascript/typescript in `body` and a project-unique `slug 1` identifier.

• Action
  Creates A New Sso Provider

  Creates a new saml 2.0 single sign-on (sso) provider for a supabase project, requiring either `metadata xml` or `metadata url` for saml idp configuration.

• Action
  Creates A New Third Party Auth Integration

  Call this to add a new third-party authentication method (oidc or jwks) to a supabase project for integrating external identity providers (e.g., for sso); the api may also support `custom jwks` if sent directly.

• Action
  Delete A Database Branch

  Permanently and irreversibly deletes a specific, non-default database branch by its `branch id`, without affecting other branches.

• Action
  Delete A Function

  Permanently deletes a specific edge function (by `function slug`) from a supabase project (by `ref`); this action is irreversible and requires prior existence of both project and function.

• Action
  Delete Project Vanity Subdomain

  Permanently and irreversibly deletes an active vanity subdomain configuration for the specified supabase project, reverting it to its default supabase url.

• Action
  Deploy Function

  Deploys edge functions to a supabase project using multipart upload.

• Action
  Disable Project Readonly

  Temporarily disables a supabase project's read-only mode for 15 minutes to allow write operations (e.g., for maintenance or critical updates), after which it automatically reverts to read-only.

• Action
  Disables Preview Branching

  Disables the preview branching feature for an existing supabase project, identified by its unique reference id (`ref`).

• Action
  Generate Type Script Types

  Generates and retrieves typescript types from a supabase project's database; any schemas specified in `included schemas` must exist in the project.

• Action
  Get Database Branch Config

  Retrieves the read-only configuration and status for a supabase database branch, typically for monitoring or verifying its settings.

• Action
  Get Project Api Keys

  Retrieves all api keys for an existing supabase project, specified by its unique reference id (`ref`); this is a read-only operation.

• Action
  Get Project S Pgbouncer Config

  Retrieves the active pgbouncer configuration (postgresql connection pooler) for a supabase project, used for performance tuning, auditing, or getting the connection string.

• Action
  Get Project Upgrade Eligibility

  Checks a supabase project's eligibility for an upgrade, verifying compatibility and identifying potential issues; this action does not perform the actual upgrade.

• Action
  Get Project Upgrade Status

  Retrieves the latest status of a supabase project's database upgrade for monitoring purposes; does not initiate or modify upgrades.

• Action
  Gets A Specific Sql Snippet

  Retrieves a specific sql snippet by its unique identifier.

• Action
  Gets A Sso Provider By Its Uuid

  Retrieves the configuration details for a specific single sign-on (sso) provider (e.g., saml, google, github, azure ad), identified by its uuid, within a supabase project.

• Action
  Gets Information About The Organization

  Fetches comprehensive details for a specific supabase organization using its unique slug.

• Action
  Gets Project S Auth Config

  Retrieves the project's complete read-only authentication configuration, detailing all settings (e.g., providers, mfa, email/sms, jwt, security policies) but excluding sensitive secrets.

• Action
  Gets Project S Postgres Config

  Retrieves the current read-only postgresql database configuration for a specified supabase project's `ref`, noting that some advanced or security-sensitive details might be omitted from the response.

• Action
  Gets Project S Postgrest Config

  Retrieves the postgrest configuration for a specific supabase project.

• Action
  Gets Project S Service Health Status

  Retrieves the current health status for a supabase project, for specified services or all services if the 'services' list is omitted.

• Action
  Gets Project S Supavisor Config

  Retrieves the supavisor (connection pooler) configuration for a specified supabase project, identified by its reference id.

• Action
  Get Table Schemas

  Retrieves column details, types, and constraints for multiple database tables to help debug schema issues and write accurate sql queries.

• Action
  List All Database Branches

  Lists all database branches for a specified supabase project, used for isolated development and testing of schema changes; ensure the project reference id is valid.

• Action
  List All Functions

  Lists metadata for all edge functions in a supabase project (specified by 'ref'), excluding function code or logs; the project must exist.

• Action
  List All Organizations

  Lists all organizations (id and name only) associated with the supabase account, excluding project details within these organizations.

• Action
  List All Projects

  Retrieves a list of all supabase projects, including their id, name, region, and status, for the authenticated user.

• Action
  List All Secrets

  Retrieves all secrets for a supabase project using its reference id; secret values in the response may be masked.

• Action
  List Members Of An Organization

  Retrieves all members of a supabase organization, identified by its unique slug, including their user id, username, email, role, and mfa status.

• Action
  Lists All Backups

  Lists all database backups for a supabase project, providing details on existing backups but not creating new ones or performing restores; availability may depend on plan and configuration.

• Action
  Lists All Buckets

  Retrieves a list of all storage buckets for a supabase project, without returning bucket contents or access policies.

• Action
  Lists All Sso Providers

  Lists all configured single sign-on (sso) providers for a supabase project, requiring the project reference id (`ref`) of an existing project.

• Action
  Lists Sql Snippets For The Logged In User

  Retrieves a list of sql snippets for the logged-in user, optionally filtered by a specific supabase project if `project ref` is provided.

• Action
  Removes A Sso Provider By Its Uuid

  Deletes a specific sso provider by its id (`provider id`) from a supabase project (`ref`), which disables it and returns its details; ensure this action will not inadvertently lock out users.

• Action
  Resets A Database Branch

  Resets an existing supabase database branch, identified by `branch id`, to its initial clean state, irreversibly deleting all its current data and schema changes.

• Action
  Retrieve A Function

  Retrieves detailed information, metadata, configuration, and status for a specific edge function using its project reference id and function slug.

• Action
  Retrieve A Function Body

  Retrieves the source code (body) for a specified serverless edge function using its project reference and function slug; this is a read-only operation that does not execute the function or return runtime logs.

• Action
  Returns Project S Readonly Mode Status

  Retrieves the read-only mode status for a specified supabase project to check its operational state; this action does not change the read-only state.

• Action
  Update A Function

  Updates an existing supabase edge function's properties (like name, slug, source code, jwt settings, import map) identified by project `ref` and `function slug`, supporting plain text code or eszip for the body.

• Action
  Update Database Branch Config

  Updates the configuration of a supabase database branch, allowing modification of its name, associated git branch, reset-on-push behavior, persistence, and status.

• Action
  Updates A Sso Provider By Its Uuid

  Updates an existing sso provider's saml metadata, associated email domains, or attribute mappings for a supabase project, identified by `ref` and `provider id`.

• Action
  Updates Project S Postgres Config

  Updates specified postgresql configuration parameters for an existing supabase project (`ref`) to optimize database performance; note that unspecified parameters remain unchanged, and caution is advised as incorrect settings can impact stability or require a restart.

• Action
  Updates Project S Postgrest Config

  Updates postgrest configuration settings (e.g., `max rows`, `db pool`, `db schema`, `db extra search path`) for a supabase project to fine-tune api performance, data exposure, and database resource usage.

• Action
  Updates Project S Supavisor Config

  Updates the supavisor (database pooler) configuration, such as `default pool size`, for an existing supabase project identified by `ref`; the `pool mode` parameter in the request is deprecated and ignored.

• Action
  Update Ssl Enforcement Config

  Updates the ssl enforcement configuration (enable/disable) for a specified supabase project's database.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.