# Vercel provider for StackQL available

> stackql is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more.

Source: https://stackql.io/blog/providers/vercel-provider-for-stackql-available

:::info

[__`stackql`__](https://github.com/stackql/stackql) is a dev tool that allows you to query and manage cloud and SaaS resources using SQL, which developers and analysts can use for CSPM, assurance, user access management reporting, IaC, XOps and more. 

:::

The StackQL provider for Vercel is now available!  Developers can directly query, analyze, and report on [__`builds`__](https://vercel.stackql.io/providers/vercel/deployments/builds/), [__`deployments`__](https://vercel.stackql.io/providers/vercel/deployments/deployments/), [__`projects`__](https://vercel.stackql.io/providers/vercel/projects/projects/), [__`domains`__](https://vercel.stackql.io/providers/vercel/dns/domains_records/), [__`log_drains`__](https://vercel.stackql.io/providers/vercel/log_drains/log_drains/), and more.  The StackQL Vercel provider can also be used to retrieve logs, manage certificates, replicate your deployment environment locally, manage Domain Name System (DNS) records, and more ... using SQL.  

More information about the Vercel provider for StackQL is available [__here__](https://vercel.stackql.io/providers/vercel/).  Here are some sample queries to get you started:  

**Projects**

```sql
SELECT id, 
name, 
accountId, 
framework,
JSON_EXTRACT(targets, '$.production.meta.githubCommitOrg') as github_org,
JSON_EXTRACT(targets, '$.production.meta.githubCommitRepo') as github_repo,
JSON_EXTRACT(targets, '$.production.meta.githubCommitRef') as github_branch
FROM
vercel.projects.projects
WHERE teamId = 'gammadata';
/* example results:
|----------------------------------|--------------|-------------------------------|-----------|--------------|--------------|---------------|                                   
|                id                |     name     |           accountId           | framework |  github_org  | github_repo  | github_branch |                                   
|----------------------------------|--------------|-------------------------------|-----------|--------------|--------------|---------------|                                   
| prj_HfRAMu9goUsA93XNrgtllDGEaabc | gammadata-io | team_YWb92ThiM8OkiGNDlDAlPDEF | nextjs    | gammastudios | gammadata.io | main          |                                   
|----------------------------------|--------------|-------------------------------|-----------|--------------|--------------|---------------|      
*/
```

**Deployments**

```sql
SELECT name,
datetime(createdAt / 1000, 'unixepoch') as created_at,
inspectorUrl as inspector_url,
ready,
SUBSTR(JSON_EXTRACT(meta, '$.githubCommitSha'), 1, 7) as github_sha
FROM vercel.deployments.deployments 
WHERE teamId = 'gammadata';
/* example results:
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
|     name     |     created_at      |                             inspector_url                              |     ready     | github_sha |                                                   
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
| gammadata-io | 2023-10-06 22:21:44 | https://vercel.com/gammadata/gammadata-io/AwVH1FfZLCB592hD1qqb4xbTZctC | 1696630955301 | 7b0b82a    |                                                   
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
| ...          | ...                 | ...                                                                    | ...           | ...        |                                                   
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
| gammadata-io | 2023-10-06 22:18:04 | https://vercel.com/gammadata/gammadata-io/2Tt4bTtQZNC5NBuuzkEYU6TwWvjX | 1696630731929 | e0e48cb    |                                                   
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
| gammadata-io | 2023-09-01 04:42:31 | https://vercel.com/gammadata/gammadata-io/7YmWz95FJH8FqNFesJURNimHrRTV | 1693543374425 | 28976a5    |                                                   
|--------------|---------------------|------------------------------------------------------------------------|---------------|------------|                                                   
*/
```

**Aliases**

```sql
SELECT 
alias, redirect
FROM vercel.aliases.aliases
WHERE teamId = 'gammadata'
AND projectId = 'prj_HfRAMu9goUsA93XNrgtllDGEaabc';
/* example results:
|---------------------------------------------------------------|----------------------|                                                                                        
|                             alias                             |       redirect       |                                                                                        
|---------------------------------------------------------------|----------------------|                                                                                        
| gammadata-io-git-feature-content-updates-gammadata.vercel.app | null                 |                                                                                        
|---------------------------------------------------------------|----------------------|                                                                                        
| ...                                                           | ...                  |                                                                                        
|---------------------------------------------------------------|----------------------|                                                                                        
| gammadata.io                                                  | www.gammadata.io     |                                                                                        
|---------------------------------------------------------------|----------------------|                                                                                        
| gammadata-io-gammadata.vercel.app                             | null                 |                                                                                        
|---------------------------------------------------------------|----------------------|  
*/
```

**Teams**

```sql
select 
id, 
name, 
slug, 
created 
from vercel.teams.teams;
/* example results:
|-------------------------------|------------|-----------|--------------------------|                                                                                                          
|              id               |    name    |   slug    |         created          |                                                                                                          
|-------------------------------|------------|-----------|--------------------------|                                                                                                          
| team_YWb92ThiM8OkiGNDlDAlPDEF | Gamma Data | gammadata | 2023-08-04T22:30:02.554Z |                                                                                                          
|-------------------------------|------------|-----------|--------------------------| 
*/
```

**Users**

```sql
select id, 
username, 
JSON_EXTRACT(billing, '$.plan') as plan, 
importFlowGitProvider as git_provider 
from vercel.user.user;
/* example results:
|--------------------------|--------------------------------|-------|--------------|                                                                                                           
|            id            |            username            | plan  | git_provider |                                                                                                           
|--------------------------|--------------------------------|-------|--------------|                                                                                                           
| 7vvpEoXx1Q9SkJzY0DyUdXYz | jeffreyaven-gammadataio        | hobby | github       |                                                                                                           
|--------------------------|--------------------------------|-------|--------------|   
*/
```

Give us a ⭐ on [__GitHub__](https://github.com/stackql/stackql)