Skip to content
Development
Command

/cap-setup-wizard

Database: sqlite, hana, or postgres

From plugin
sap-skills
40469 skills31 agents69 commands8 MCP
Install
$ npx -y skills add secondsky/sap-skills --agent claude-code

How it fires

How this command gets triggered: by you, by Claude, or both.

  • Fires itselfClaude auto-loads it when your prompt matches the work.
  • You can call itInvoke it directly when you want it.
  • Slash command/cap-setup-wizard

Context preview

What this command does when you run it.

Database: sqlite, hana, or postgres

Command definition

cap-setup-wizard.md
name: cap-setup-wizard
description: Interactive guide for setting up new CAP projects with framework and database selection
allowed-tools:
  - Read
  - Bash
  - AskUserQuestion
argument-hint: "[nodejs|java|typescript] [sqlite|hana|postgres]"
arguments:
  - name: framework
    description: "Target framework: nodejs, java, or typescript"
    required: false
  - name: database
    description: "Database: sqlite, hana, or postgres"
    required: false

Shell Snippet Notes

  • Shell snippets assume Bash on Linux/macOS, WSL2, or Git Bash.
  • Install the command-specific tooling shown near each snippet before running it.
  • Confirm before running commands that delete files, change ownership, deploy, or modify remote systems.

Output Contract

Return a setup plan, selected stack/runtime assumptions, generated-file checklist, safe commands, and confirmation points before writes. Default to planning unless the user explicitly requests project generation and provides or confirms a target directory.

CAP Project Setup Wizard

Interactive guide for initializing new SAP Cloud Application Programming Model projects.

Quick Start

Node.js + SQLite (Development)

cds init my-bookshop --add tiny-sample
cd my-bookshop
npm install
cds watch

**Access**: http://localhost:4004

Node.js + HANA (Production-Ready)

cds init my-bookshop --add hana,mta
cd my-bookshop
npm install
cds add hana

TypeScript + SQLite

cds init my-bookshop --add typescript,tiny-sample
cd my-bookshop
npm install
cds watch

Java + HANA

cds init my-bookshop --add java,hana,mta
cd my-bookshop
mvn spring-boot:run

Framework Selection

Node.js (JavaScript)

**Best for**: Rapid development, prototyping, lightweight services

**Runtime**: Node.js 18+ LTS

**Key packages**:

  • `@sap/cds` - Core CAP framework
  • `express` - HTTP server
  • `sqlite3` - Development database

**Project Structure**:

my-bookshop/
├── db/
│   └── schema.cds
├── srv/
│   ├── catalog-service.cds
│   └── catalog-service.js
└── package.json

**Advantages**:

  • Fastest development cycle
  • Smallest learning curve
  • Largest CAP community
  • Best for prototypes and MVPs

TypeScript

**Best for**: Type safety, large teams, enterprise applications

**Runtime**: Node.js 18+ LTS + TypeScript 5+

**Key packages**:

  • `@sap/cds` - Core CAP framework
  • `typescript` - Type system
  • `@types/node` - Node.js type definitions

**Additional setup**:

npm install --save-dev typescript @types/node
npx tsc --init

**Advantages**:

  • Compile-time type checking
  • Better IDE support
  • Refactoring safety
  • Enterprise-grade code quality

Java (Spring Boot)

**Best for**: Enterprise applications, existing Java ecosystems

**Runtime**: Java 17+ LTS

**Key dependencies**:

  • `com.sap.cds:cds-starter-spring-boot`
  • `org.springframework.boot:spring-boot-starter-web`

**Build tool**: Maven or Gradle

**Advantages**:

  • Strong typing
  • Mature ecosystem
  • Enterprise patterns
  • Integration with Java systems

Database Selection

SQLite (Development Only)

**Best for**: Local development, quick testing

**Setup**: Auto-configured with Node.js projects

**Deploy**: `cds deploy --to sqlite:db/data.db`

**Advantages**:

  • Zero configuration
  • Fast startup
  • No external dependencies
  • Perfect for development

**Limitations**:

  • Single-user only
  • Not for production
  • Limited concurrency

SAP HANA Cloud (Production)

**Best for**: Production SAP BTP applications

**Setup**:

cds add hana
cds add mta

**Deploy**: Via MTA build and Cloud Foundry CLI

**Advantages**:

  • Production-grade performance
  • Multi-tenancy support
  • Advanced HANA features
  • Native SAP BTP integration

**Requirements**:

  • SAP BTP account
  • HANA Cloud instance
  • Cloud Foundry CLI

PostgreSQL (Alternative Production)

**Best for**: Non-SAP cloud environments

**Setup**:

npm add @cap-js/postgres

**Configuration**: Add postgres binding in package.json

**Advantages**:

  • Open source
  • Wide cloud support
  • Cost-effective
  • Standard SQL features

Additional Features

Add Multitenancy

cds add multitenancy

**When to use**: Building SaaS applications

**Enables**:

  • Tenant isolation
  • Subscription management
  • Tenant-specific extensions

Add UI (Fiori Elements)

cds add fiori

**When to use**: Building Fiori applications

**Generates**:

  • UI5 application structure
  • Navigation
  • Annotations

Add Authentication

cds add xsuaa

**When to use**: Production applications

**Configures**:

  • XSUAA service binding
  • xs-security.json
  • Role-based access control

Add Extensibility

cds add extensibility

**When to use**: SaaS applications with customer extensions

**Enables**:

  • Field extensions
  • Custom logic
  • UI extensions

Post-Setup Checklist

  • [ ] Run `npm install` to install dependencies
  • [ ] Verify `cds watch` starts successfully
  • [ ] Access service at http://localhost:4004
  • [ ] Check Fiori preview at http://localhost:4004/fiori-preview.html
  • [ ] Review generated package.json configuration
  • [ ] Set up version control (git init)
  • [ ] Configure .gitignore (automatically included)
  • [ ] Plan deployment strategy (Cloud Foundry, Kyma, etc.)

Common Project Configurations

Configuration 1: Local Development

cds init my-project --add tiny-sample
cd my-project
npm install
cds watch

**Use case**: Learning CAP, rapid prototyping

Configuration 2: Full-Stack with UI

cds init my-project --add hana,mta,fiori,xsuaa
cd my-project
npm install

**Use case**: Production Fiori application

Configuration 3: Multi-Tenant SaaS

cds init my-project --add hana,mta,xsuaa,multitenancy,extensibility
cd my-project
npm install

**Use case**: Enterprise SaaS application

Configuration 4: Microservice API

cds init my-service --add hana,mta,xsuaa
cd my-service
npm install
# Remove app/ folder if no UI
Read more
Ships withsap-skills

40 SAP development plugins with evidence-tracked verification SAP development plugins for AI coding assistants, with public-source or package-registry verification tracked where available.

Get the whole plugin