Announcing the Vercel Source Plugin
December 14, 2022
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 (opens in a new tab) section to configure required credentials for the plugin.
Below are some query examples to get you started.
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.
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)
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.
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).