rakazo
6.2k
Get started

Metabase

Metabase is an open-source business intelligence tool that lets you ask questions about your data and visualize answers as charts, graphs, and dashboards.

266 actionsAPI key

Connect Metabase

What your bot can do in Metabase

Looks up

  • Get all collectionsRetrieve all collections that the current user has read permissions for.
  • Get All DatabasesRetrieve a list of all Database instances configured in Metabase.
  • Get API CardList all cards (questions) available to the authenticated user in Metabase.
  • Get Card by IDRetrieve a specific card (question) by its ID.
  • Get Collection by IDRetrieve detailed information about a Metabase collection by its ID.
  • Get Collection by IDFetch a specific Metabase collection with standard details added.
  • Get Collection ItemsRetrieve items from a specific Metabase collection.
  • Get Current UserRetrieve information about the currently authenticated user.
  • Get Dashboard by IDRetrieve details of a specific Metabase dashboard by ID.
  • Get Dashboard by IDRetrieve a dashboard by its ID from Metabase.
Show 123 more
  • Get Database By IDRetrieve a single database by ID from Metabase.
  • Get Database DetailsRetrieve complete details for a specific database in Metabase.
  • Get Table By IDRetrieve basic table information by ID from Metabase.
  • Search Metabase objectsSearch Cards, Dashboards, Collections, Tables, Databases, and Pulses for a substring.
  • Check Database HealthCheck the health status of a specific database connection in Metabase.
  • Generate Random Security TokenGenerate a cryptographically secure random token for Metabase.
  • Get ActionRetrieve a Metabase action by ID.
  • Get Action Execute ParametersFetch values for filling in action execution parameters.
  • Get All AlertsRetrieve all alerts in Metabase.
  • Get all Metabase actionsRetrieve all actions available in the Metabase instance.
  • Get all native query snippetsRetrieve all native query snippets available in the Metabase instance.
  • Get All PulsesRetrieve all pulses (scheduled reports/subscriptions) in Metabase.
  • Get All SegmentsRetrieve all segments from Metabase.
  • Get All TimelinesRetrieve all timelines in Metabase.
  • Get All User Key-Values in NamespaceRetrieve all key-value pairs in a given namespace for the current user.
  • Get API GlossaryRetrieve all glossary items from Metabase.
  • Get Automagic Comparison DashboardRetrieve an automagic comparison dashboard comparing a cell in one entity with another entity.
  • Get Automagic DashboardGenerate an automagic dashboard for a given entity.
  • Get Automagic DashboardRetrieve an automagic dashboard for a specified entity with its ID.
  • Get automagic dashboard by ruleReturn an automagic dashboard for a specific entity using a dashboard template with rule prefix.
  • Get Automagic Dashboard CandidatesRetrieve automagic dashboard candidates for a specific database.
  • Get Automagic Dashboard Cell AnalysisReturn an automagic dashboard analyzing a specific cell in an entity's data.
  • Get Automagic Dashboard Cell AnalysisReturn an automagic dashboard analyzing a specific cell in an entity's data.
  • Get Automagic Dashboard Cell RuleFetch an automagic dashboard analyzing a specific cell in a table or query.
  • Get Automagic Dashboard Cell Rule AnalysisFetch an automagic dashboard analyzing a specific cell using a template rule.
  • Get Automagic Dashboard Query MetadataRetrieve all metadata for an automagic dashboard for the specified entity type and ID.
  • Get Automagic Dashboard Query MetadataRetrieve all metadata for an automagic dashboard for a specific entity and ID.
  • Get Automagic Dashboard with Rule and TemplateRetrieve an automagic dashboard for a specified entity using a specific rule prefix and dashboard template.
  • Get Automagic Dashboards CompareReturn an automagic comparison dashboard for entity with id compared with comparison-entity with comparison-entity-id-or-query.
  • Get Billing API VersionRetrieve the billing API version information for the Metabase Enterprise Edition instance.
  • Get Card DashboardsGet a list of dashboards containing a specific card.
  • Get Card DashboardsGet a list of dashboards that a specific card appears in.
  • Get Card Query MetadataGet comprehensive query metadata for a Metabase card (saved question).
  • Get Card SeriesRetrieve series data for a specific card.
  • Get Card SeriesFetch a list of cards compatible as series with a specified card.
  • Get Card Table Foreign KeysRetrieve foreign key relationships for a card-based virtual table.
  • Get Card Virtual Table Query MetadataRetrieve metadata for a virtual table created from a card (saved question).
  • Get Collection ItemsFetch items from a specific Metabase collection.
  • Get Collection TimelinesRetrieve timelines associated with a specific Metabase collection.
  • Get Collection TimelinesFetch timelines associated with a specific Metabase collection.
  • Get Collection TreeRetrieve the collection tree structure from Metabase.
  • Get Current Remote Sync TaskRetrieve the current remote sync task status in Metabase.
  • Get Current User Login HistoryRetrieve login history for the currently authenticated user.
  • Get Dashboard HTML PreviewRetrieve an HTML preview rendering of a dashboard.
  • Get Dashboard Parameter RemappingGet parameter remapping for a dashboard parameter value.
  • Get Dashboard Parameter ValuesFetch available values for a specific dashboard parameter.
  • Get Dashboard Params RemappingFetch the remapped value for a given dashboard parameter in Metabase.
  • Get Dashboard Query MetadataGet all of the required query metadata for the cards on a dashboard.
  • Get Dashboard Related EntitiesRetrieve related entities for a Metabase dashboard.
  • Get Dashboard Related EntitiesRetrieve related entities for a Metabase dashboard.
  • Get Database Autocomplete SuggestionsRetrieve autocomplete suggestions for table and field names in a database.
  • Get Database Autocomplete SuggestionsGet autocomplete suggestions for table and field names in a Metabase database.
  • Get Database Card Autocomplete SuggestionsGet card autocomplete suggestions for a specific database in Metabase.
  • Get Database Card Autocomplete SuggestionsReturn a list of Card autocomplete suggestions for a given query in a given Database.
  • Get Database DatasetsRetrieve tables (models and metrics) from a virtual database schema in Metabase.
  • Get Database FieldsRetrieve all fields from a specific database in Metabase.
  • Get Database FieldsRetrieve all field metadata from a Metabase database.
  • Get Database HealthcheckCheck if a Metabase database can currently connect.
  • Get Database MetadataRetrieve complete metadata for a specific database including all tables and fields.
  • Get Database MetadataRetrieve complete metadata for a specific database including all tables and fields.
  • Get Database SchemasRetrieve all schemas with tables for a specific database in Metabase.
  • Get Database Settings AvailableGet all database-local settings and their availability for a given database.
  • Get Database Syncable SchemasRetrieve all syncable schemas for a specific database in Metabase.
  • Get Embedding Hub ChecklistRetrieve the embedding hub checklist status for Metabase Enterprise Edition.
  • Get Entity Revision HistoryRetrieve the revision history for a Metabase entity (dashboard, card, metric, or segment).
  • Get Field Related EntitiesRetrieve related entities for a Metabase field.
  • Get Field RemappingFetch remapped field values for a specific field in Metabase.
  • Get Field SummaryGet summary statistics for a Metabase field by its ID.
  • Get Field ValuesRetrieve distinct values for a Metabase field.
  • Get Model Index DetailsRetrieve details of a specific model index by its ID.
  • Get Model Index ValuesRetrieve indexed field values for a specific Metabase model.
  • Get ModelIndex by IDRetrieve a ModelIndex by ID.
  • Get Most Recently Viewed DashboardRetrieve the most recently viewed dashboard for the authenticated user.
  • Get Native Query Snippet by IDRetrieve a specific native query snippet by its ID.
  • Get Native Query Snippet by IDRetrieve a specific native query snippet by its ID.
  • Get NotificationsRetrieve notifications from Metabase with optional filtering.
  • Get Popular ItemsGet the list of 5 popular items on the Metabase instance.
  • Get Public Card by UUIDFetch a publicly-accessible card by its public UUID and return card information including query definition, visualization settings, and…
  • Get Public oEmbed MetadataGet oEmbed metadata for public Metabase resources.
  • Get Public Pivot Card QueryFetch a publicly-accessible pivot card and return query results including data rows, column metadata, and query status.
  • Get Pulse by IDRetrieve a specific pulse (subscription) by its ID.
  • Get Pulse Form Input ConfigurationRetrieve configuration information for creating or updating Pulses (scheduled email reports).
  • Get Pulse Preview CardRetrieve the HTML preview of a Metabase card formatted for pulse emails.
  • Get Pulse Preview CardGet HTML rendering of a Metabase card by ID.
  • Get Pulse Preview Card InfoRetrieve preview information for a Metabase card formatted for pulse emails.
  • Get Pulse Preview Card InfoGet JSON object containing HTML rendering of a card and additional information.
  • Get Pulse Preview DashboardRetrieve the pulse preview for a specific dashboard by its ID.
  • Get Recent Activity ViewsRetrieve recently viewed items in Metabase.
  • Get Resource DependentsGet dependents of a resource in Metabase's dependency graph.
  • Get Revision by ID and EntityRetrieve a specific revision by ID and entity type.
  • Get Revision History by IDRetrieve the complete revision history for a Metabase entity by its ID.
  • Get Root CollectionFetch the Root Collection and its top-level objects.
  • Get Root Collection TimelinesRetrieve all timelines associated with the root collection.
  • Get Search WeightsRetrieve the current search weight configuration for the Metabase instance.
  • Get Session PropertiesRetrieve all global session properties and their values that are public.
  • Get Stale Data By IDRetrieve stale data information by ID from Metabase Enterprise Edition.
  • Get Stale Entities from CollectionRetrieve stale entities (cards and dashboards) from a Metabase collection that haven't been used recently.
  • Get Table DataRetrieve data from a specific table in Metabase.
  • Get Table Data by IDRetrieve data from a specific Metabase table by ID.
  • Get Table Foreign KeysRetrieve foreign key relationships for a Metabase table.
  • Get Table Foreign KeysGet all foreign keys whose destination is a field that belongs to a specific table.
  • Get Table Query MetadataRetrieve metadata about a table useful for running queries.
  • Get Table Query MetadataGet metadata about a Table useful for running queries.
  • Get Timeline by IDFetch a timeline by its ID from Metabase.
  • Get Timeline by IDFetch a timeline by its ID.
  • Get Timeline EventRetrieve a timeline event by ID.
  • Get Timeline EventFetch a timeline event by ID.
  • Get Uploaded TablesRetrieve all uploaded tables in Metabase Enterprise Edition.
  • Get User Audit InfoGet audit info for the current authenticated user.
  • Get User BookmarksRetrieve all bookmarks for the authenticated user.
  • Get User by IDRetrieve a specific user by their ID.
  • Get User by IDFetch a Metabase user by their ID.
  • Get User Key-Value by NamespaceRetrieve all user key-value pairs for a specified namespace.
  • Get User Key-Value SettingRetrieve a user-specific key-value pair from Metabase storage.
  • Get User Key-Value SettingRetrieve a user-specific key-value pair from Metabase storage.
  • Get User RecipientsRetrieve users for recipient selection.
  • Get Virtual Database DatasetsRetrieve all datasets from a Metabase virtual database.
  • Search Card Parameter ValuesSearch for values of a specific parameter in a Metabase card.
  • Search Card Parameter ValuesFetch possible values for a card parameter that match a search query.
  • Search dashboard parameter valuesSearch for dashboard parameter values in Metabase.
  • Search Dashboard Parameter ValuesFetch possible values of a dashboard parameter that contain the search query.
  • Search Field ValuesSearch for field values in Metabase that start with a given string.
  • Validate Password Reset TokenValidate a password reset token in Metabase.

Takes action

  • Copy CardCreate a copy of an existing Metabase card (question) by its ID.
  • Copy DashboardCopy an existing Metabase dashboard.
  • Create CardCreate a new Metabase card (question or model).
  • Create CollectionCreate a new Metabase collection for organizing content.
  • Create DashboardCreate a new Metabase dashboard.
  • Delete CardDelete a Metabase card (question) by its ID.
  • Delete CardHard delete a Metabase card.
  • Delete DashboardDelete a Metabase dashboard by its ID.
  • Delete DashboardHard delete a Metabase dashboard by its ID.
  • Execute Dataset QueryExecute a query against a Metabase database and retrieve results.
Show 123 more
  • Update Card by IDUpdate a specific card (question) by its ID.
  • Update CollectionUpdate an existing Metabase collection.
  • Update DashboardUpdate a Metabase dashboard by its ID.
  • Update DashboardUpdate a Metabase dashboard by ID.
  • Update DatabaseUpdate a Database in Metabase.
  • Update Database ConfigurationUpdate a database configuration in Metabase.
  • Bulk Move CardsBulk move cards to a collection or remove them from collections.
  • Bulk Move Cards to CollectionBulk move multiple Metabase cards into a target collection or remove them from collections.
  • Cancel Current Remote Sync TaskCancel the current active Remote Sync task in Metabase Enterprise Edition.
  • Check Password ComplexityCheck if a password meets Metabase's configured password complexity rules.
  • Check Snippet DependenciesCheck dependencies for a native query snippet in Metabase Enterprise Edition.
  • Convert Query to Native SQLConvert a Metabase query to native SQL format.
  • Copy DashboardCreate a copy of an existing Metabase dashboard.
  • Create BookmarkCreate a new bookmark for a Metabase item (card, dashboard, collection, or dataset).
  • Create BookmarkCreate a new bookmark for a Metabase item (card, dashboard, collection, or dataset).
  • Create BookmarkCreate a bookmark for a Metabase item (card, dashboard, or collection).
  • Create Dashboard in CollectionCreate a new dashboard in a specific Metabase collection.
  • Create Dashboard SubscriptionCreate a dashboard subscription using Metabot tools.
  • Create Field DimensionSet the dimension for a field at the specified ID in Metabase.
  • Create Glossary EntryCreate a new glossary entry in Metabase.
  • Create Model IndexCreate a new model index in Metabase.
  • Create native query snippetCreate a new native query snippet in Metabase.
  • Create NotificationCreate a new notification in Metabase.
  • Create PulseCreate a new pulse (scheduled report/subscription) in Metabase.
  • Create TimelineCreate a new timeline in Metabase.
  • Delete ActionDelete an Action from Metabase.
  • Delete ActionDelete a Metabase action by its ID.
  • Delete API CacheDelete/clear cached data in Metabase for specific entities.
  • Delete BookmarkDelete a bookmark from a Metabase item (card, dashboard, or collection).
  • Delete BookmarkDelete a bookmark by model and ID.
  • Delete Field DimensionRemove the dimension associated with a field at the specified ID.
  • Delete Glossary EntryDelete a glossary entry from Metabase.
  • Delete Glossary ItemDelete a glossary item by ID.
  • Delete Model IndexDelete a Metabase model index by its ID.
  • Delete Model IndexDelete a ModelIndex by ID from Metabase.
  • Delete TimelineDelete a timeline by ID.
  • Delete TimelineDelete a Metabase timeline and cascade delete all its associated events.
  • Delete Timeline EventDelete a timeline event by ID.
  • Delete Timeline EventDelete a Metabase timeline event.
  • Delete User Key-ValueDelete a user key-value pair from Metabase.
  • Delete User Key-Value PairDelete a user key-value pair by namespace and key.
  • Delete User SubscriptionsDelete all Alert and DashboardSubscription subscriptions for a User.
  • Delete User SubscriptionsDelete all Alert and DashboardSubscription subscriptions for a User.
  • Disable Database Model PersistenceDisable model persistence for a Metabase database.
  • Discard Database Field ValuesDiscard all saved field values for a specific database.
  • Discard Database Field ValuesDiscard all saved field values for a specific database.
  • Discard Field ValuesDiscard the FieldValues belonging to a Metabase field.
  • Discard Field ValuesDiscard cached FieldValues for a specific field.
  • Discard Table Field ValuesDiscard the FieldValues belonging to the Fields in a Metabase Table.
  • Discard Table Field ValuesDiscard cached FieldValues for all Fields belonging to a specific Table.
  • Dismiss Database SpinnerDismiss the spinner for a specific database.
  • Dismiss Database Sync SpinnerManually set the initial sync status of a Database and corresponding tables to complete.
  • Execute Card QueryExecute a query for a saved Metabase card/question and retrieve results.
  • Execute Dashboard Card QueryExecute a query for a specific card within a dashcard on a dashboard.
  • Execute Dashboard Pivot QueryExecute a pivot table query for a specific card on a dashboard.
  • Execute Pivot Card QueryExecute a pivot query on a Metabase card and return the results.
  • Execute Pivot Table QueryExecute a pivot table query and retrieve results.
  • Filter RecordsFilter records from a Metabase data source using metabot tools.
  • Generate InsightsGenerate insights for a table using Metabot tools.
  • Get Card Dashboard AssociationsRetrieve dashboard associations for given card IDs.
  • Get Current UserRetrieve information about the current authenticated user in a Metabase metabot conversation.
  • Get Dashboard DetailsRetrieve dashboard details for a Metabase metabot conversation.
  • Get Dataset Parameter ValuesFetch parameter values for dataset fields in Metabase.
  • Get Dataset Query MetadataRetrieve query metadata for a dataset query including databases, tables, fields, and snippets.
  • Get Document Details via MetabotRetrieve document details using Metabase metabot tools.
  • Get Metabot SnippetsRetrieve SQL snippets for a Metabase metabot conversation.
  • Get Query DetailsGet query details using Metabot tools API.
  • Get Snippet DetailsRetrieve SQL snippet details via Metabase metabot tools.
  • Get Table DetailsRetrieve comprehensive table details via Metabase metabot tools.
  • Metabot SearchSearch Metabase entities using the metabot search API.
  • Query Datasource via MetabotQuery a Metabase datasource using Metabot tools.
  • Record Recent ActivityRecord recent activity for a Metabase item.
  • Remap Dataset Parameter ValueRemap dataset parameter values in Metabase.
  • Rescan Database Field ValuesTrigger a manual rescan of field values for a specific database.
  • Rescan Field ValuesManually trigger an update for the FieldValues for a specific field.
  • Rescan Table Field ValuesManually trigger an update for FieldValues for Fields belonging to a specific Table.
  • Rescan Table Field ValuesTrigger a manual rescan of field values for a specific table.
  • Revert Entity to Previous RevisionRevert a Metabase entity (card, dashboard, document, or segment) to a previous revision.
  • Run Card Pivot QueryRun a pivot table query on a Metabase card (question).
  • Run Card QueryRun the query associated with a Card and return its results.
  • Run Dashboard Pivot DashCard QueryRun a pivot table query for a specific DashCard.
  • Save Dashboard to CollectionSave a denormalized dashboard description into a collection.
  • Search Dataset Parameter ValuesSearch for parameter values in datasets when editing cards or dashboards.
  • Search Metabase Items (Metabot V2)Search Metabase items using the Metabot search v2 endpoint.
  • Send NotificationTrigger sending an unsaved notification in Metabase.
  • Send Password Reset EmailSend a password reset email when user has forgotten their password.
  • Submit Bug Report to SlackSubmit a bug report to Slack via Metabase's bug reporting endpoint.
  • Submit Product FeedbackSubmit product feedback to Metabase.
  • Sync Database SchemaTrigger a schema synchronization for a specific database.
  • Sync Table SchemaTrigger a manual update of the schema metadata for a specific Table.
  • Sync Table SchemaTrigger a manual update of the schema metadata for a specific Table.
  • Translate Entity IDsTranslate Metabase entity IDs (21-character strings) to their numeric IDs.
  • Trigger Database Field Values RescanTrigger a manual scan of field values for a Database.
  • Trigger Database Schema SyncTrigger a manual update of the schema metadata for a Database.
  • Unpersist CardUnpersist a Metabase card/model.
  • Unpersist CardUnpersist a Metabase card by its ID.
  • Unpersist DatabaseDisable model persistence for a specific database.
  • Update ActionUpdate an existing Action in Metabase.
  • Update Action by IDUpdate an existing Metabase action by its ID.
  • Update Bookmark OrderingUpdate the order of bookmarks for the authenticated user.
  • Update Collection by IDUpdate an existing Metabase collection by its ID.
  • Update Dashboard CardsUpdate dashboard cards and tabs.
  • Update Dashboard Cards (Deprecated)Bulk update dashboard cards and tabs.
  • Update Field MetadataUpdate a Metabase field by its ID.
  • Update Field MetadataUpdate metadata for a Metabase field by its ID.
  • Update Field ValuesUpdate field values and human-readable values for a Field whose semantic type is category/city/state/country or whose base type is…
  • Update Glossary EntryUpdate an existing glossary entry in Metabase.
  • Update Glossary Entry by IDUpdate an existing glossary entry in Metabase by its ID.
  • Update Native Query SnippetUpdate an existing native query snippet by ID.
  • Update Native Query Snippet by IDUpdate an existing native query snippet by its ID.
  • Update PulseUpdate an existing pulse (scheduled report/subscription) by ID.
  • Update Pulse by IDUpdate an existing pulse (scheduled report/subscription) by ID.
  • Update Search WeightsUpdate search weights configuration in Metabase.
  • Update Table by IDUpdate a Table in Metabase by its ID.
  • Update Table Field Display OrderUpdate the display order of fields in a Metabase table.
  • Update Table Fields OrderReorder fields in a Metabase table.
  • Update Table MetadataUpdate a Metabase table by its ID.
  • Update Table MetadataUpdate a Metabase table metadata by its ID.
  • Update TimelineUpdate a Metabase timeline by its ID.
  • Update Timeline by IDUpdate an existing timeline by its ID.
  • Update Timeline EventUpdate an existing Metabase timeline event by its ID.
  • Update Timeline Event by IDUpdate an existing timeline event by its ID.
  • Update User by IDUpdate an existing Metabase user by their ID.

More data apps