steampipe plugin install trello

Table: trello_my_board - Query Trello Boards using SQL

Trello is a web-based, Kanban-style, list-making application which is a subsidiary of Atlassian. Originally made by Fog Creek Software in 2011, it was spun out to form the basis of a separate company in 2014 and later sold to Atlassian in January 2017. The service operates via cloud computing, with the system being operated using JavaScript, HTML and CSS.

Table Usage Guide

The trello_my_board table provides insights into personal boards within Trello. As a project manager, explore board-specific details through this table, including board name, description, privacy settings, and associated metadata. Utilize it to uncover information about boards, such as their visibility settings, the members associated with each board, and the activity on each board.

Examples

Basic info

Explore the Trello boards you're a part of, including their names, descriptions, and associated organizations. This can help you manage your work more efficiently by giving you a comprehensive view of your tasks and projects.

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

List my open boards

Explore your active Trello boards to gain insights into their details and assess their organization affiliations. This allows for efficient board management by focusing only on boards that are currently open and active.

select
id,
name,
description,
id_organization,
closed,
url
from
trello_my_board
where
not closed;
select
id,
name,
description,
id_organization,
closed,
url
from
trello_my_board
where
closed is not 1;

List my pinned boards

Discover the details of your preferred boards on Trello. This query allows you to quickly identify and access your favorite boards, enhancing your ability to manage and prioritize tasks.

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

List my starred boards

Explore your favorite Trello boards, gaining insights into their names, descriptions, associated organizations, and URLs. This is useful for quickly accessing and managing your preferred projects.

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

List my boards in a specific organization

Explore the boards that you have in a particular organization, helping you to manage and track your projects effectively. This can be particularly useful when you are part of multiple organizations and need to quickly identify all your boards within a specific one.

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

List my boards with a specific label

Explore which of your Trello boards have been tagged with a 'Blocked' label. This can help you quickly identify and prioritize tasks that are facing obstacles.

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

List preferences for each board

Discover the individual preferences for each board you have on Trello. This can be useful to understand and optimize your board settings for better project management.

select
tmb.id,
tmb.name,
id_organization,
p.key as pref_key,
p.value as pref_value
from
trello_my_board as tmb,
jsonb_each_text(prefs) p;
select
tmb.id,
tmb.name,
id_organization,
p.key as pref_key,
p.value as pref_value
from
trello_my_board as tmb,
json_each(prefs) p;

List custom fields for each board

Explore the customization options of each board by identifying the unique fields associated with them. This analysis can assist in understanding the various customization settings and configurations applied to each board, providing insights into their unique characteristics and usage.

select
tmb.id,
tmb.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_my_board as tmb,
jsonb_array_elements(custom_fields) c;
select
tmb.id,
tmb.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_my_board as tmb,
json_each(custom_fields) as c;

Schema for trello_my_board

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
closedbooleanIndicates whether the board is closed.
custom_fieldsjsonbThe custom fields associated to the board.
descriptiontextA description or summary of the board.
idtextThe unique identifier for the board.
id_organizationtextThe id of the organization associated with the board.
label_namesjsonbThe label names of the board.
member_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the member.
nametextThe name of the board.
pinnedbooleanIndicates whether the board is pinned.
prefsjsonbAdditional settings for the board.
short_urltextThe shortened URL of the board.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
starredbooleanIndicates whether the board is starred.
subscribedbooleanIndicates whether the board has been subscribed.
titletextThe title of the board.
urltextThe URL of the board.

Export

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_my_board