Table: trello_board - Query Trello Boards using SQL

Trello is a web-based, Kanban-style, list-making application which is a subsidiary of Atlassian. It allows users to create, manage, and organize boards, which represent projects, and within boards, cards, which represent tasks. Trello Boards are the basic units of a Trello workflow and can be used to represent a project, a team, or even a company.

Table Usage Guide

The trello_board table provides insights into Trello Boards within the Trello application. As a project manager or team leader, explore board-specific details through this table, including names, descriptions, privacy settings, and more. Utilize it to uncover information about boards, such as those that are public, the ones that are private, and the verification of privacy settings.

Examples

Basic info

Explore the basic details of your Trello boards, including determining if they are closed or open, to better manage your organization's workflow and tasks. This can help you assess each board's status and understand its role within your organization.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board;

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board;

List all boards that are open

Discover the segments that are still active within your organization. This query is particularly useful for tracking ongoing projects and tasks, offering a clear view of all open boards.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  not closed;

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  closed = 0;

List all boards that are pinned

Explore which boards have been marked as important or frequently used by identifying those that have been pinned. This can aid in quickly accessing key information and prioritizing tasks.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  pinned;

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  pinned = 1;

List all boards that are starred

Discover the segments that are marked as important or highlighted, allowing you to focus on priority areas or tasks within your project management tool.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  starred;

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  starred = 1;

List all boards in a specific organization

Discover the segments that belong to a specific organization by examining all the boards associated with it. This can aid in understanding the structure and operations of the organization.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  id_organization = '1234ce0f581f4de8a0dc184c';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  id_organization = '1234ce0f581f4de8a0dc184c';

List the details of a specific board

Explore a specific board's details, such as its name, status, and associated organization, to gain insights into its usage and relevance. This can be beneficial in understanding the board's context and role within your Trello organization.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  id = '1234ce0f581f4de8a0dc184c';

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  id = '1234ce0f581f4de8a0dc184c';

List all boards with a specific label

Explore which Trello boards have been marked with a 'Blocked' label to understand areas of your projects that might be facing obstacles. This can help identify potential bottlenecks and improve project management efficiency.

select
  tb.id,
  tb.name,
  tb.id_organization,
  l.key as label_key,
  l.value as label_value
from
  trello_board as tb,
  jsonb_each_text(label_names) l
where
  l.value = 'Blocked';

select
  tb.id,
  tb.name,
  tb.id_organization,
  l.key as label_key,
  l.value as label_value
from
  trello_board as tb,
  json_each(label_names) as l
where
  l.value = 'Blocked';

List preferences of each board

Explore the various preferences set for each board in an organization. This can help in understanding the customization and settings applied to different boards, aiding in effective management and control.

select
  tb.id,
  tb.name,
  tb.id_organization,
  p.key as pref_key,
  p.value as pref_value
from
  trello_board as tb,
  jsonb_each_text(prefs) p;

select
  tb.id,
  tb.name,
  tb.id_organization,
  p.key as pref_key,
  p.value as pref_value
from
  trello_board as tb,
  json_each(prefs) p;

List all subscribed boards

Explore which Trello boards you're subscribed to, helping you manage and stay updated with the boards that matter to you. This is beneficial in scenarios where you need to quickly identify your active subscriptions amongst numerous boards.

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  subscribed;

select
  id,
  name,
  description,
  id_organization,
  closed,
  url
from
  trello_board
where
  subscribed = 1;

List the custom fields of each board

Explore the customization of different boards by analyzing the unique fields associated with each. This can be useful in understanding the organization and categorization of information within each board.

select
  id,
  name,
  c ->> 'ID' as custom_field_id,
  c ->> 'Name' as custom_field_name,
  c ->> 'IDModel' as custom_field_model_id,
  c ->> 'IDModelType' as custom_field_model_type_id,
  c ->> 'FieldGroup' as custom_field_group,
  c ->> 'Pos' as custom_field_pos,
  c ->> 'Type' as custom_field_type,
  c ->> 'Display' as custom_field_display,
  c ->> 'Options' as custom_field_options
from
  trello_board,
  jsonb_array_elements(custom_fields) c;

select
  trello_board.id,
  trello_board.name,
  json_extract(c.value, '$.ID') as custom_field_id,
  json_extract(c.value, '$.Name') as custom_field_name,
  json_extract(c.value, '$.IDModel') as custom_field_model_id,
  json_extract(c.value, '$.IDModelType') as custom_field_model_type_id,
  json_extract(c.value, '$.FieldGroup') as custom_field_group,
  json_extract(c.value, '$.Pos') as custom_field_pos,
  json_extract(c.value, '$.Type') as custom_field_type,
  json_extract(c.value, '$.Display') as custom_field_display,
  json_extract(c.value, '$.Options') as custom_field_options
from
  trello_board,
  json_each(trello_board.custom_fields) c;

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 steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- trello

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

steampipe_export_trello --config '<your_config>' trello_board