CloudQuery News

Announcing the Vercel Source Integration

Kemal Hadimli

Kemal Hadimli

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.
Kemal Hadimli

Written by Kemal Hadimli

Kemal is a senior software engineer at CloudQuery with experience in high performance front-and-backend programming and application design.

Turn cloud chaos into clarity

Find out how CloudQuery can help you get clarity from a chaotic cloud environment with a personalized conversation and demo.

Join our mailing list

Subscribe to our newsletter to make sure you don't miss any updates.

Legal

© 2024 CloudQuery, Inc. All rights reserved.

We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.