CloudQuery News
Announcing the Vercel Source Integration
If you're not familiar with the Vercel platform, we recommend you visit their homepage. If you're looking for an example of what you can do with it, you may be interested to know that the CloudQuery website is built on Vercel!
CloudQuery now supports pulling resources from Vercel using Vercel's API.
Take a look at the CloudQuery Vercel Integration Documentation 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.
Ready to dive deeper? Contact CloudQuery here or join the CloudQuery Community to connect with other users and experts.
You can also try out CloudQuery locally with our quick start guide or explore the CloudQuery Platform (currently in beta) for a more scalable solution.
Written by Kemal Hadimli
Kemal is a senior software engineer at CloudQuery with experience in high performance front-and-backend programming and application design.
