Table: mongodbatlas_project - Query MongoDB Atlas Projects using SQL

A MongoDB Atlas Project is a logical grouping of resources that are deployed in MongoDB Atlas, MongoDB's fully managed cloud database service. Projects in MongoDB Atlas serve as a means to manage access and security for the databases and clusters within them. It provides a centralized way to manage database configurations, user roles, IP whitelists, and more.

Table Usage Guide

The mongodbatlas_project table provides insights into projects within MongoDB Atlas. As a database administrator or DevOps engineer, explore project-specific details through this table, including project ID, cluster count, and associated metadata. Utilize it to uncover information about projects, such as their associated clusters, user roles, and IP whitelists.

Examples

Basic info

Explore the basic details of your MongoDB Atlas projects by identifying each project's unique identifier and name. This can help you keep track of your projects and maintain an organized database.

select
  id,
  name
from
  mongodbatlas_project;

select
  id,
  name
from
  mongodbatlas_project;

List projects with at least 1 cluster

Discover the projects that have one or more clusters associated with them, allowing you to identify areas of resource allocation and usage. This can be beneficial in understanding project resource utilization and managing resources efficiently.

select
  id,
  name,
  cluster_count
from
  mongodbatlas_project
where
  cluster_count > 0;

select
  id,
  name,
  cluster_count
from
  mongodbatlas_project
where
  cluster_count > 0;

Schema for mongodbatlas_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cluster_count	bigint		The number of Atlas clusters deployed in the project.
id	text	=	A unique identifier of the project.
name	text		The name of the project.
org_id	text		The unique identifier of the Atlas organization to which the project belongs.
organization_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.

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)" -- mongodbatlas

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

steampipe_export_mongodbatlas --config '<your_config>' mongodbatlas_project