Table: vercel_team - Query Vercel Teams using SQL

A Vercel Team is a collaborative workspace in Vercel, a deployment and hosting platform. It allows multiple users to work together on projects, share resources, and manage permissions. Teams can be used to manage both open-source projects and commercial projects in a shared workspace.

Table Usage Guide

The vercel_team table provides insights into teams within Vercel. As a developer or DevOps engineer, explore team-specific details through this table, including team ID, name, slug, description, and more. Utilize it to uncover information about teams, such as their creation time, collaboration details, and the users associated with each team.

Examples

List all teams

Explore which teams are currently set up in your Vercel environment. This can help in managing team access and permissions effectively.

select
  id,
  slug,
  name,
  description
from
  vercel_team;

select
  id,
  slug,
  name,
  description
from
  vercel_team;

Get role of the authenticated user in each team

The first query allows you to find out the role of the authenticated user in each team, which can be useful in managing team permissions and roles. The second query provides information on the number of invoiced seats per team, which can be essential for budgeting and resource allocation.

select
  name,
  membership ->> 'role' as role
from
  vercel_team;

select
  name,
  json_extract(membership, '$.role') as role
from
  vercel_team;

Number of invoiced seats per team

select
  name,
  billing -> 'invoiceItems' -> 'teamSeats' ->> 'quantity' as seats
from
  vercel_team;

select
  name,
  json_extract(
    json_extract(
      json_extract(billing, '$.invoiceItems'),
      '$.teamSeats'
    ),
    '$.quantity'
  ) as seats
from
  vercel_team;

Schema for vercel_team

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allow_project_transfers	boolean
avatar	text		Avatar for the team.
billing	jsonb
created	timestamp with time zone		Time when the team was created.
creator_id	text		ID of the user who created the team.
description	text
id	text	=	Unique identifier of the team.
invite_code	text
membership	jsonb		Membership of the team.
name	text		Name of the team.
platform_version	text
preview_deployment_suffix	jsonb
profiles	jsonb
resource_config	jsonb
slug	text	=	Slug of the team.
soft_block	jsonb
staging_prefix	text
updated_at	timestamp with time zone		Time when the team was last updated.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- vercel

You can pass the configuration to the command with the --config argument:

steampipe_export_vercel --config '<your_config>' vercel_team