Does this tool connect to my OCI account?

No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.

Are the generated configurations production-ready?

The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

OCI NoSQL Table Builder

StorageOCI

Build NoSQL Database table schema configurations with DDL statements, indexes, and capacity settings.

OCI NoSQL Database Configuration

Build NoSQL Database table schema configurations with DDL statements, indexes, TTL, and capacity settings.

Required Fields

compartmentIddisplayNameddlStatementtableLimits

{
  "compartmentId": "ocid1.compartment.oc1..aaaaaaaexample",
  "displayName": "user-sessions-table",
  "description": "NoSQL table for user session data with TTL",
  "ddlStatement": "CREATE TABLE IF NOT EXISTS user_sessions (session_id STRING, user_id STRING, created_at TIMESTAMP(3), expires_at TIMESTAMP(3), device_info JSON, PRIMARY KEY(session_id)) USING TTL 24 HOURS",
  "tableSchema": {
    "columns": [
      { "name": "session_id", "type": "STRING", "isPrimaryKey": true },
      { "name": "user_id", "type": "STRING", "isShardKey": true },
      { "name": "created_at", "type": "TIMESTAMP", "precision": 3 },
      { "name": "expires_at", "type": "TIMESTAMP", "precision": 3 },
      { "name": "device_info", "type": "JSON" },
      { "name": "ip_address", "type": "STRING" },
      { "name": "is_active", "type": "BOOLEAN", "defaultValue": true }
    ],
    "primaryKey": ["session_id"],
    "shardKey": ["user_id"],
    "ttl": {
      "defaultTTLDays": 1,
      "maxTTLDays": 30
    },
    "indexes": [
      {
        "name": "idx_user_id",
        "fields": ["user_id"],
        "isUnique": false
      },
      {
        "name": "idx_created_at",
        "fields": ["created_at"],
        "isUnique": false
      }
    ]
  },
  "tableLimits": {
    "capacityMode": "PROVISIONED",
    "maxReadUnits": 200,
    "maxWriteUnits": 100,
    "maxStorageInGBs": 50
  },
  "onDemandConfig": {
    "capacityMode": "ON_DEMAND",
    "maxStorageInGBs": 100
  },
  "isAutoReclaimable": false,
  "freeformTags": {
    "application": "session-store",
    "team": "backend"
  }
}

Generated Output

Output will appear here...

About This Tool

Build NoSQL Database table schema configurations with DDL statements, indexes, and capacity settings. This tool helps OCI engineers generate valid configurations quickly without consulting documentation, reducing errors and accelerating infrastructure deployment. All processing runs in your browser with no data sent to external servers.

When to Use This Tool

•Generating oci nosql table configurations for new infrastructure deployments.
•Validating existing configurations against best practices before applying changes.
•Learning OCI service configuration patterns through interactive examples.
•Accelerating infrastructure-as-code development by producing correct JSON/YAML starting points.

Frequently Asked Questions

Does this tool connect to my OCI account?: No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.
Are the generated configurations production-ready?: The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

Related Learning Guides

Autonomous Database on OCI20 min read
OCI Object Storage & Tiers16 min read

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.