Tutorials

How to sync from Trello to PostgreSQL with CloudQuery

We have recently released the CloudQuery Trello integration and in this guide, I will walk you through the full setup of a sync from Trello to a PostgreSQL database using our PostgreSQL destination integration.

Trello is a popular tool for task management in DevOps and engineering teams because it is simple, but sometimes you just need a bit more reporting to understand how your team is doing and how you could improve.

To sync with Trello, you will need to create a Trello Power-Up and get its API key and a secret token. When I first learned about it, I was worried it would be too complicated and I'd need to write a lot of code, at least that's what Atlassian's documentation made me think at the first look. It is luckily much simpler than that, there's zero code to write.

Let's get started.

Setting up the Power-Up

First make sure you have a Trello account and that you are logged in.

Next visit the Power-Ups administration. If this is your first time on this page, you may need to read and agree to the Trello Developer Terms. After that, you will get to your Apps dashboard.

Trello board settings showing the Power-Ups administration panel

Click New and fill in the form to create a new Power-Up. You do not need to worry about the Iframe connector URL. Despite being marked as required, it actually isn't.

Trello custom Power-Up creation form with name and configuration fields

After you submit the form, you can generate the API key.

Trello API key page before generating a key, showing the empty key field
Trello API key page showing the generated API key ready to copy

The first text box contains the API key to use in CloudQuery configuration, save it.

Next, generate the app token. Click the blue Token link in the hint next to the API key (highlighted red in the screenshot above). This will take you to an authorization page.

Trello API token authorization page requesting permission to access account data

Scroll down, click Allow, and you'll get the token to use with CloudQuery. Save it.

Now the only thing remaining is setting up the actual sync. I'll use CloudQuery Platform but if you prefer running locally, here's how you can download CloudQuery CLI. Find the full example config at the end of this post on CloudQuery example configurations.

Setting up the Sync

For this step, you will need the API key and the token from the Trello Power-Up created above, and a connection string to a PostgreSQL database.

If you don't have a PostgreSQL at hand, just head to Neon and sign up for a free account. It's really easy to start with.

Log into the CloudQuery Platform and from the Syncs tab, create a new Sync.

First, define the destination. Since the plan is to sync to a PostgreSQL database, you can leave the defaults and just fill in the connection string in the Secrets section. If you use Neon, it will probably look like this:

postgresql://user:[email protected]/database?sslmode=require

In the next step, select the Trello source integration. The default config will load and all you need to do is to fill in the API key and the token in the Secrets section again.

CloudQuery Platform secrets configuration with Trello API key and token stored as environment variables

With the configuration ready, progress to the next page, and run the sync. It should only take a few seconds for the sync to finish. You can then connect to the PostgreSQL database and explore the synced data.

Here's an example query to list all overdue cards with their assignees:

SELECT tbc.name, tbc.short_url, tbc.due, string_agg(tbm.username, ', ') AS assignees FROM trello_board_cards tbc
JOIN trello_board_lists l on l.id = tbc.id_list
LEFT OUTER JOIN trello_board_members tbm on tbm.id = ANY(tbc.id_members)
WHERE l.name in ('Todo', 'In Progress')
AND tbc.due < current_timestamp
AND tbc.due_complete = false
GROUP BY tbc.name, tbc.short_url, tbc.due

Example Sync Configuration for local syncs

Here's a full example configuration using environment variables in case you want to run the sync with CloudQuery CLI locally:

kind: source
spec:
name: 'trello'
path: 'cloudquery/trello'
registry: 'cloudquery'
version: 'v1.1.0'
tables: ['*']
destinations:
- 'postgresql'
spec:
# required
api_key: '${TRELLO_API_KEY}'
# required
token: '${TRELLO_APP_TOKEN}'
---
kind: destination
spec:
name: postgresql
path: cloudquery/postgresql
registry: cloudquery
version: 'v6.1.3'
spec:
connection_string: '${PG_CONNECTION_STRING}'

Create your sync now


Want to see CloudQuery in action? Schedule a demo with our team or check out the platform documentation to learn more.

Got feedback or suggestions? Join the CloudQuery community to connect with other users and experts, or message our team directly here if you have any questions.

Try CloudQuery yourself

Self-hosted, open source, and free to start. Or schedule a demo to see the managed version.

Related posts

Tutorials

How to Automatically Update CloudQuery Integrations with Renovate

Configure Renovate to automatically update CloudQuery integration versions in your YAML files using the CloudQuery Hub API as a custom datasource.

Matthew M

Matthew M

May 20, 2026

AWS

Security

Tutorials

Finding AWS Unrestricted Outbound Access in 2026: EC2, Lambda, and Beyond

Find EC2, Lambda, and ECS Fargate resources with unrestricted outbound access in AWS using SQL. Why egress controls still break attack chains in 2026.

Joe Karlsson

Joe Karlsson

May 5, 2026

AWS

Security

Tutorials

AWS IAM Identity Center with Google Workspace as an IdP: 2026 Step-by-Step Guide

Set up AWS IAM Identity Center with Google Workspace: SAML authentication, SCIM user provisioning, and group sync with CLI or ssosync. Updated for 2026.

Joe Karlsson

Joe Karlsson

May 5, 2026

GCP

Security

Tutorials

Creating Cross-Project Service Accounts in GCP (Console + gcloud CLI)

Create a GCP service account that reads across all your projects with one credential. Covers gcloud CLI, org-level vs.

Joe Karlsson

Joe Karlsson

May 5, 2026

AWS

Cloud Infrastructure

Security

Tutorials

Integrate AbuseIPDB Threat Intelligence with CloudQuery

Enrich your cloud asset inventory with AbuseIPDB threat intelligence to identify public cloud IPs with known abuse reports.

Joe Karlsson

Joe Karlsson

April 20, 2026

AWS

Cloud Infrastructure

Tutorials

How to Query ipinfo.io Data with CloudQuery

Learn how to enrich your cloud asset inventory with ipinfo.io IP geolocation and threat intelligence data using CloudQuery.

Joe Karlsson

Joe Karlsson

April 20, 2026

AWS

Security

Tutorials

AWS IAM Identity Center (Formerly AWS SSO): The Complete 2026 Guide

AWS IAM Identity Center replaced AWS SSO in 2022. Learn how to set it up, configure permission sets, use the AWS CLI, and audit access with CloudQuery.

Joe Karlsson

Joe Karlsson

April 6, 2026

AWS

Tutorials

AWS Pinpoint Is Being Deprecated: How to Assess Your Migration Scope

AWS Pinpoint reaches end of support October 2026. Query your Pinpoint usage across all accounts to find what needs migrating before the deadline.

Joe Karlsson

Joe Karlsson

March 24, 2026

Tutorials

Moving Data from PostgreSQL to MotherDuck

How to sync PostgreSQL data to MotherDuck using CloudQuery, with both one-off batch and continuous CDC streaming options for serverless analytics.

Herman Schaaf

Herman Schaaf

March 13, 2026

Own your pipeline.
Own your data.