webhookdb - CLI for WebhookDB https://github.com/webhookdb/webhookdb. WebhookDB replicates any API into a database, so you have immediate, reliable access to all your data.

To create an account and get started, run:

webhookdb auth login

The CLI will guide you from there.

The CLI also gives you quick access to the WebhookDB documentation:

webhookdb docs html # Open a browser to https://docs.webhookdb.com
webhookdb docs tui # Display the CLI Reference in the terminal

Source code: https://github.com/webhookdb/webhookdb-cli

Documentation: https://docs.webhookdb.com/docs/cli-reference.md

webhookdb

[--debug]
[--quiet|-q]

Usage:

webhookdb [GLOBAL OPTIONS] command [COMMAND OPTIONS] [ARGUMENTS...]

--debug:

--quiet, -q: Do not print messages. Mostly used for collection endpoints, where you just want the returned data, not the help message.

These commands control the auth process.

Print information about the current user.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

Sign up or log in.

--token, -t="": One-time-password token received in your email after running 'auth login'.

--username, -u, --email="": Takes an email.

Log out of your current session.

--remove, -r: If given, remove all WebhookDB preferences.

Start backfilling all the resources available to the service integration.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Reset any stored API keys and secrets associated with backfilling this integration.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Command namespace for interacting with your organization's database and tables.

Print the database connection url for an organization.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

List all tables in an organization's database.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Execute query on organization's database.

--color, -c: Display colors. Default true if tty.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--query, -u="": Query string to execute using your connection.

Roll the credentials for an organization's database to something newly randomly generated.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Write out commands that can be used to generate a FDW against your WebhookDB database and import them into materialized views. See flags for further usage.

--all: Write a single SQL statement containing FDW and view creation code. Default if neither --fdw or --views are passed.

--fdw: Write the FDW SQL to stdout

--fetch="": fetch_size option used during server creation (default: 50000)

--into-schema="": Name of the schema to import the remote tables into (in IMPORT FOREIGN SCHEMA public INTO <into schema> call). (default: webhookdb_remote)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--raw: If given, print the raw SQL returned from the server. Useful if you want to pipe through jq or something similar.

--remote="": The remote server name, used in the CREATE SERVER <remote> call (default: webhookdb_remote)

--views: Write the SQL to create the materialized views to stdout

--views-schema="": Create materialized views in this schema. You can use 'public' if you do not want to qualify webhookdb tables. (default: webhookdb)

Rename the database table associated with the integration.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--new-name, -n="": The new name of the table. Valid table names must adhere to the following rules: must begin with an ASCII letter, contain only ASCII letters, numbers, underscores, dashes, and spaces, can begin and end with double quotes, and must otherwise be a valid Postgres identifier.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Command namespace for interacting with your organizations database migrations.

Enqueue a migration of all your organization's data to a new database.

--admin-url, -a="":

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--readonly-url, -r="":

List all database migrations.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Work with the WebhookDB docs and guide.

Open a browser to the WebhookDB Getting Started guide.

Open a browser to the WebhookDB CLI reference.

Build the docs for the app.

--docsite: If given, format this for use on docs.webhookdb.com

--format="": One of: markdown, man

--help, -h: show help

Output the SQL DDL (CREATE TABLE command) to create a DB table that matches what is in WebhookDB. This can be used to generate .sql files that can be run as part of test database fixturing.

--service, -s="": Name of the service. Run webhookdb services list to see a list of all services available to your organization.

Make sure that you're working on the correct organization when you create an integration.

Create an integration for the given organization.

--confirm, -c: If there is already an integration for this service, you will be prompted to confirm you want to create a new integration. Pass --confirm to automatically accept this prompt and always create a new integration.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--service, -s="": Name of the service. Run webhookdb services list to see a list of all services available to your organization.

Delete an integration and its table.

--confirm, -c="": Confirm this action by providing a value of the integration's table name. Will be prompted if not provided.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Display information about given integration.

--field, -f="": The field that you want information about.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

List all integrations for the given organization.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Ensure all the necessary fields are set to receive webhooks.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Reset the webhook secret for this integration.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Roll the API key used to access this integration. Only relevant for certain integrations.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Get statistics about webhooks for this integration.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Create and activate an organization, invite new members, and change membership roles.

Change the default organization for any command you run.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Change the role of members of your organization.

--role, -r="": Role name, like 'member' or 'admin'.

--usernames="": Takes multiple emails.

Close down this organization.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Create and activate an organization.

--name, -n="": Name of the new organization. The unique key for the org is derived from this name.

Invite a user to your organization.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--role, -r="": Role to assign the new organization member

--username, -u, --email="": Takes an email.

Join an organization using a join code. You can also see your pending invites with webhookdb org list.

--code, -c="": Invitation code sent to the new member. Has 'join-' prefix.

List all organizations that you are a member of.

Display the name and slug of the currently active organization.

List all members of the given organization.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Remove a member from an organization.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--username, -u, --email="": Takes an email.

Change the name or billing email of the organization. (Note: the org key is immutable and will not change.)

--field, -f="": The field that you want to change.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--value, -v="": The new value for the chosen field

Replay webhooks received by WebhookDB. Useful if webhooks were rejected due to invalid secrets/verification and need to be re-processed.

Note that the maximum window that can be replayed is managed by the server, and is normally 4 hours. To replay a larger window, issue multiple webhookdb replay calls.

--after, -a="": Replay webhooks received after this time. Takes precedence over --hours. If neither are given, use 1 hour.

--before, -b="": Replay webhooks received before this time. Timestamp can be anything time-like, preferably ISO8601 (ie, 2012-11-22T06:00:00Z). Defaults to now.

--hours, -r="": Number of hours before now (or the --before value) to replay webhooks. (default: 0)

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. If not given, replay webhooks for all integrations in the current organization.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Manage your library of saved queries, including ones that can be accessed publicly.

Create a new saved query.

--description, -d, --desc="": Explain what this query is used for.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--public: If true, the query can be accessed publicly, without authentication. Allows a saved query to be used on public dashboards or websites, without exposing a database connection string or allowing public access to a database.

--sql="": SQL statement to run.

List all saved queries.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Update a new saved query.

--field, -f="": The field that you want to change.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--saved-query, -q="": Saved query opaque id. Run webhookdb saved-query list to see a list of all your saved queries.

--value, -v="": The new value for the chosen field

Display information about given saved query.

--field, -f="": The field that you want information about.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--saved-query, -q="": Saved query opaque id. Run webhookdb saved-query list to see a list of all your saved queries.

Run the query.

--color, -c: Display colors. Default true if tty.

--saved-query, -q="": Saved query opaque id. Run webhookdb saved-query list to see a list of all your saved queries.

Delete this saved query.

--saved-query, -q="": Saved query opaque id. Run webhookdb saved-query list to see a list of all your saved queries.

Work with available services that can be hooked up to reflect data to WebhookDB.

List all available services.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Work with your WebhookDB subscription.

Get information about an organization's software subscription.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Open stripe portal to edit subscription.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--plan, -p="": Plan name, like 'yearly', 'monthly', etc. Use webhookdb subscription plans to see available plans.

Print information about the WebhookDB pricing plans.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Replicate data in a WebhookDB table to another database.

Create a database sync target for the specified integration. Data will be automatically synced from the integration's WebhookDB table into the database specified by the connection string. PostgresQL and SnowflakeDB databases are supported.

--connection-url, -u="": The connection string for the database that WebhookDB should write data to.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--period="": Number of seconds between syncs. (default: 0)

--schema="": Schema (or namespace) to write the table into. Default to no schema/namespace.

--table="": Table to create and update. Default to match the table name of the service integration.

Delete the database sync target and stop any further syncing. The database being synced to is not modified.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--target, -t="": Sync target opaque id. Use webhookdb dbsync list to see a list of all your database sync targets.

List all database sync targets for the given organization.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Update the database sync target. Use webhookdb dbsync list to see all database sync targets.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--period="": Number of seconds between syncs. (default: 0)

--schema="": Schema (or namespace) to write the table into. Default to no schema/namespace.

--table="": Table to create and update. Default to match the table name of the service integration.

--target, -t="": Sync target opaque id. Use webhookdb dbsync list to see a list of all your database sync targets.

Update the username and password used to connect to the database being synced to.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--password, -p="": Takes a password.

--target, -t="": Sync target opaque id. Use webhookdb dbsync list to see a list of all your database sync targets.

--user, -u="": Takes a username.

Trigger a database sync to the sync target. The database sync will happen at the earliest possible moment since the last sync, no matter how long the configured period is on the sync target.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--target, -t="": Sync target opaque id. Use webhookdb dbsync list to see a list of all your database sync targets.

Replicate data in a WebhookDB table to another http endpoint.

Create a http sync target for the specified integration. Data will be automatically synced from the integration's WebhookDB table into the http endpoint specified by the connection string. Only https urls are supported.

--connection-url, -u="": The connection string for the http endpoint that WebhookDB should write data to.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--pagesize="": Max number of rows WebhookDB sends the sync target in each call. (default: 0)

--period="": Number of seconds between syncs. (default: 0)

Delete the http sync target and stop any further syncing. The http endpoint being synced to is not modified.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--target, -t="": Sync target opaque id. Use webhookdb httpsync list to see a list of all your http sync targets.

List all http sync targets for the given organization.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Update the http sync target. Use webhookdb httpsync list to see all http sync targets.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--pagesize="": Max number of rows WebhookDB sends the sync target in each call. (default: 0)

--period="": Number of seconds between syncs. (default: 0)

--target, -t="": Sync target opaque id. Use webhookdb httpsync list to see a list of all your http sync targets.

Update the username and password used to connect to the http endpoint being synced to.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--password, -p="": Takes a password.

--target, -t="": Sync target opaque id. Use webhookdb httpsync list to see a list of all your http sync targets.

--user, -u="": Takes a username.

Trigger a http sync to the sync target. The http sync will happen at the earliest possible moment since the last sync, no matter how long the configured period is on the sync target.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--target, -t="": Sync target opaque id. Use webhookdb httpsync list to see a list of all your http sync targets.

Update the version of the CLI in-place.

--path="": Download the new version to the given path. Default to the current executable.

--version="": Use a specific version rather than latest. Can be used to downgrade.

Manage endpoints that will be notified when WebhookDB data is updated.

Create a new notification that WebhookDB will call on every data update.

--integration, -i="": Integration identifier. This can either be the service name, the table name, or the opaque id, which is a unique code that starts with 'svi_'. Run webhookdb integrations list to see a list of all your integrations.

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

--secret="": Random secure secret to use to sign notifications coming from WebhookDB.

--url="": Full URL to the endpoint that will be POSTed to whenever this organization or integration is updated.

List all created notifications.

--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)

--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.

Send a test event to the notification subscription with the given ID.

--notification, -n="": Notification opaque id. Run webhookdb notification list to see a list of all your notification subscriptions.

Delete this notification subscription, so no future events will be sent.

--notification, -n="": Notification opaque id. Run webhookdb notification list to see a list of all your notification subscriptions.

Print version and exit.

--time: Print the build time as well.