webhookdb
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
SYNOPSIS
webhookdb
[--debug]
[--quiet|-q]
Usage:
webhookdb [GLOBAL OPTIONS] command [COMMAND OPTIONS] [ARGUMENTS...]
Table of contents
webhookdb- SYNOPSIS
- GLOBAL OPTIONS
authbackfilldbdocsfixtures,fixtureintegrations,integrationorg,orgs,organization,organizationsreplay,replayssaved-query,saved-queries,custom-query,custom-queriesservices,servicesubscription,subscriptions,sub,subsdbsync,synchttpsyncupdate,upgradenotification,notifications,webhook,webhooksversion
GLOBAL OPTIONS
--debug:
--quiet, -q: Do not print messages. Mostly used for collection endpoints, where you just want the returned data, not the help message.
COMMANDS
auth
These commands control the auth process.
whoami
Print information about the current user.
--format, -f="": Format of the output. One of: json, csv, table, raw (default: table)
login, signup, signin, register
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.
logout
Log out of your current session.
--remove, -r: If given, remove all WebhookDB preferences.
backfill
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
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.
db
Command namespace for interacting with your organization’s database and tables.
connection
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.
tables
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.
sql
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-credentials
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.
fdw
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-table
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.
migrations
Command namespace for interacting with your organizations database migrations.
start
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
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.
docs
Work with the WebhookDB docs and guide.
guide
Open a browser to the WebhookDB Getting Started guide.
manual, html
Open a browser to the WebhookDB CLI reference.
build
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
fixtures, fixture
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.
integrations, integration
Make sure that you’re working on the correct organization when you create an integration.
create
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
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.
info
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
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.
setup
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
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-key
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.
stats
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.
org, orgs, organization, organizations
Create and activate an organization, invite new members, and change membership roles.
activate
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.
changerole, change-role
Change the role of members of your organization.
--role, -r="": Role name, like ‘member’ or ‘admin’.
--usernames="": Takes multiple emails.
close
Close down this organization.
--org, -o="": Takes an org key. Run webhook org list to see a list of all your org keys.
create
Create and activate an organization.
--name, -n="": Name of the new organization. The unique key for the org is derived from this name.
invite
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
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
List all organizations that you are a member of.
current
Display the name and slug of the currently active organization.
members
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
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.
update
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, replays
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.
saved-query, saved-queries, custom-query, custom-queries
Manage your library of saved queries, including ones that can be accessed publicly.
create
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
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, edit, modify
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
info
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
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
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.
services, service
Work with available services that can be hooked up to reflect data to WebhookDB.
list
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.
subscription, subscriptions, sub, subs
Work with your WebhookDB subscription.
info
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.
edit
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.
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.
dbsync, sync
Replicate data in a WebhookDB table to another database.
create
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
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
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
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-creds
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
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.
httpsync
Replicate data in a WebhookDB table to another http endpoint.
create
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
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
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
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-creds
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
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, upgrade
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.
notification, notifications, webhook, webhooks
Manage endpoints that will be notified when WebhookDB data is updated.
create
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
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.
test
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
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.
version
Print version and exit.
--time: Print the build time as well.