Announcing the Vercel Source Plugin

Announcing the Vercel Source Plugin

December 14, 2022

Kemal Hadimli
Name
Kemal Hadimli
Twitter
@disq

CloudQuery is an open-source, extendable framework that gives you a single-pane-of-glass to your cloud-infrastructure. Today, we are happy to announce the release of the Vercel source plugin for CloudQuery.

If you're not familiar with the Vercel platform, we recommend you visit their homepage (opens in a new tab).

CloudQuery now supports pulling resources from Vercel (opens in a new tab) using Vercel's API.

Take a look at our Configuration section to configure required credentials for the plugin.

Below are some query examples to get you started.

Detect domain registrations that will expire soon

If you have more than just one domain, keeping track of which one will expire soon can be a problem. Here's a query to check how many days there are left on each registration:

select name, expires_at, date_trunc('day', expires_at - current_timestamp) as days_left from vercel_domains where (expires_at - interval '90 day') < current_timestamp order by 1;

This query would output a table of domain names that are going to expire within the next 90 days:

      name      |   expires_at         | days_left
----------------+----------------------+-----------
 yourdomain.co  | 2023-01-28T08:09:41Z | 44 days
 yourdomain.com | 2023-01-31T15:58:08Z | 47 days
(2 rows)

Vercel also provides an auto-renewal facility (opens in a new tab) which will automatically renew your domain registration when it's about to expire.

Get all Vercel team members

Using the query below you can list all Vercel team members across multiple teams.

select t.name AS team, u.username, u.name, u.role from vercel_teams t join vercel_team_members u on u.team_id=t.id order by 1, 2;

This will return list of users per team and their role:

   name   |   username   | name         |  role
------------+--------------+------------+--------
 yourteam | user1        | User Name    | MEMBER
 yourteam | user2        |              | MEMBER
 yourteam | user3        | Another User | OWNER
(3 rows)

Get a list of name servers

select name, intended_nameservers, custom_nameservers, nameservers from vercel_domains order by 1;

This query will return a list of domains and their name servers.

What's next

We are going to continue expanding the Vercel source plugin, adding support for more resources. Interested in seeing another plugin? Check out Creating a New Plugin and/or open an issue on our GitHub (opens in a new tab).