neon-cli

# Neon CLI Guide

Neon is a serverless PostgreSQL platform providing instant database provisioning, branching, and scaling. This guide provides essential workflows and quick references for common Neon operations.

## Quick Start

```bash
# Check Neon CLI installation
neon --version

# Authenticate with Neon
neon auth

# View current user
neon me

# List all projects
neon projects list

# Create new project
neon projects create --name myapp --region aws-us-east-1
```

## Common Workflows

### Workflow 1: Create Project with Database

```bash
# Authenticate first
neon auth

# Create project
neon projects create --name myapp --region aws-us-east-1

# Get project ID (from output or list)
neon projects list

# Create database
neon databases create --branch-id <branch_id> --name app_db

# Create application role
neon roles create --branch-id <branch_id> --name app_user --password secret123

# Get connection string
neon connection-string
```

### Workflow 2: Feature Branch Development

```bash
# Create feature branch from main
neon branches create --project-id <project_id> --name feature/new-api --parent-id <main_branch_id>

# Add compute to branch
neon branches add-compute <feature_branch_id> --size small

# Create database for feature
neon databases create --branch-id <feature_branch_id> --name app_db

# Get connection string for development
neon connection-string feature/new-api

# After testing, delete feature branch
neon branches delete <feature_branch_id>
```

### Workflow 3: Multi-Environment Setup

```bash
# Create production branch with medium compute
neon branches create --project-id <project_id> --name production
neon branches add-compute <prod_branch_id> --size medium

# Create staging branch with small compute
neon branches create --project-id <project_id> --name staging --parent-id <prod_branch_id>
neon branches add-compute <staging_branch_id> --size small

# Create development branch
neon branches create --project-id <project_id> --name development --parent-