steampipe plugin install stripe

Table: stripe_account - Query Stripe Accounts using SQL

Stripe Account is a resource within the Stripe payment processing platform that represents an account on Stripe. These accounts can be associated with individual users or businesses and contain information about the account's details, balances, capabilities, and settings. They are integral to managing and understanding the financial transactions occurring on your Stripe platform.

Table Usage Guide

The stripe_account table provides insights into the accounts within your Stripe platform. As a financial analyst or platform administrator, explore account-specific details through this table, including balances, capabilities, and settings. Utilize it to uncover information about each account, such as the account type, its capabilities, and the currencies it can handle.


List all accounts

Explore all your Stripe accounts to gain a comprehensive overview and better manage your online transactions. This could be particularly useful for businesses with multiple accounts, helping to streamline their financial operations.


Are card payments active for this account?

Explore whether card payments are enabled for a given account. This can be useful for businesses to ensure they can process card payments and maintain smooth operations.

(capabilities -> 'card_payments') :: bool as card_payments
json_extract(capabilities, '$.card_payments') as card_payments

Schema for stripe_account

_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
business_profilejsonbBusiness information about the account.
business_typetextThe business type.
capabilitiesjsonbA hash containing the set of capabilities that was requested for this account and their associated states. Keys are names of capabilities. You can see the full list here. Values may be active, inactive, or pending.
charges_enabledbooleanWhether the account can create live charges.
companyjsonbInformation about the company or business. This field is available for any business_type.
countrytextThe account’s country.
createdtimestamp with time zoneTime at which the account was created.
default_currencytextThree-letter ISO currency code representing the default currency for the account.
deletedbooleanTrue if the customer is marked as deleted.
details_submittedbooleanWhether account details have been submitted. Standard accounts cannot receive payouts before this is true.
emailtextAn email address associated with the account. You can treat this as metadata: it is not used for authentication or messaging account holders.
external_accountsjsonbExternal accounts (bank accounts and debit cards) currently attached to this account.
idtextUnique identifier for the account.
individualjsonbInformation about the person represented by the account. This field is null unless business_type is set to individual.
metadatajsonbSet of key-value pairs that you can attach to an account. This can be useful for storing additional information about the account in a structured format.
payouts_enabledbooleanWhether Stripe can send payouts to this account.
requirementsjsonbInformation about the requirements for the account, including what information needs to be collected, and by when.
settingsjsonbOptions for customizing how the account functions within Stripe.
tos_acceptancejsonbDetails on the acceptance of the Stripe Services Agreement.
typetextThe Stripe account type. Can be standard, express, or custom.


This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the script:

/bin/sh -c "$(curl -fsSL" -- stripe

You can pass the configuration to the command with the --config argument:

steampipe_export_stripe --config '<your_config>' stripe_account