announcement
Announcing the Vercel Source Plugin
![Kemal Hadimli](/images/people/kemal.jpg)
Kemal Hadimli •
If you're not familiar with the Vercel platform, we recommend you visit their homepage.
CloudQuery now supports pulling resources from Vercel 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 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.