LogoLogo
CtrlK
  • GITBOOK - HOW WE WORK
  • Welcome to CrateDB
  • Getting started
    • First steps with CrateDB (Live)
    • Going further (Live)
  • Data modelling
    • Relational data (Ivan - Live)
    • JSON data (Daryl - Live)
    • Time series data (Karyn - Live)
    • Geospatial data (Kenneth Live)
    • Full-text data (Brian - Live)
    • Vector data (Juan - Live)
  • Query capabilities
    • Aggregations (Andreas)
    • Ad-hoc queries (Andreas)
    • Search (Ivan)
      • Full-text search
      • Geospatial search
      • Vector search
      • Hybrid search
    • AI integration (Andreas)
  • Tutorials & Examples
    • Data models
      • Multi-model data modeling
      • Time series
      • Semantic search
    • Data pipeline
      • AWS
      • Azure
      • GCP
    • Query acceleration
      • Datawarehouses
    • AI/ML
      • ML workflows
      • Chatbots (RAG/TAG)
      • AI Agents
    • Industries
      • Equipment maintenance
  • Drivers and integrations
    • Ciient interfaces (Kenneth)
      • Drivers
      • PostgreSQL wire protocol
      • HTTP SQL endpoint
    • CrateDB CLIs (Karyn)
      • CrateDB shell (Crash)
        • Getting started
        • Running Crash
        • Commands
        • Troubleshooting
        • Response formats
      • CrateDB Cloud CLI (Croud)
        • Getting started
        • Configuration
        • Commands
        • User roles
    • Data sources
      • Files (Ivan - need review)
      • Foreign Data Wrappers (who? - need review)
      • Change Data Capture
        • MongoDB CDC (Juan - review)
      • Streaming platforms
        • Kafka (Daryl - ongoing)
          • Confluent Quick Start
          • Docker Quick Start
        • Apache Flink (Daryl)
      • Sensors and telemetry
        • MQTT Broker (Live - need review)
        • Telegraf (Live - need review)
      • HTTP APIs (Ivan - need review)
      • Data integration platforms
        • Estuary (On hold - Bug fix needed - Ivan)
        • Ingestr
    • Data visualization (Ivan)
    • AI/ML integrations
    • Data transformation
      • dbt
    • MCP
  • Reference manual
    • Database schema
      • Table creation
        • Creating tables
        • Data types
          • Primitive types
          • Container types
            • Objects
            • Arrays
          • Geographic types
          • Other types
          • Type casting
          • PostgreSQL compatibility
        • Columns
          • Constraints
            • Primary key strategies
          • Column policy
          • Column store
          • Generated columns
          • System columns
        • Indexes
          • Index types
          • Full-text indexes
            • Full-text analyzers
              • Char filters
              • Tokenizers
              • Token filters
        • Partitioning
        • Sharding & replica
          • Sharding
          • Replication
          • Shard allocation filtering
        • Checking tables
      • Altering tables
        • Updating parameters
        • Adding columns
        • Renaming columns
        • Closing and opening tables
        • Renaming tables
        • Rerouting shards
      • Views
    • Storage & Indexing
      • Hybrid Index
      • Storage and consistency
      • BLOB store
    • Querying
      • Native SQL syntax
      • Joins
        • Join types
        • Join algorithms
        • Join optimizations
      • CTEs
      • Specific functions
        • User-defined functions
        • Time series functions
      • Server-side cursors
    • Insert/Update/Delete
      • Insert
      • Update
      • Delete
    • Security
  • Advanced guides
    • Clustering concepts
      • Components of a CrateDB node
      • Multi-node setup
      • Cluster behavior
      • Resiliency
    • Reference architectures
    • Installation guide
    • Deployment guide
    • Migration guides
    • Upgrading guide
      • Planning
      • Rolling Upgrade
      • Full Restart Upgrade
  • Database management
    • Cluster configuration
      • Node settings
      • Cluster-wide settings
      • Session settings
      • Logging
      • Environment Variables
    • Cluster sizing
      • Infrastructure
      • Sizing
      • Benchmarking
    • Cluster management
      • Snapshots
      • Cross-Cluster Replication
    • Performance tuning
      • General considerations
        • Sharding
        • Memory
        • Storage
        • Indexes
      • Circuit breaker
      • Optimizing INSERTs
        • Configuration tuning
        • Insert methods
        • Unnesting
        • Bulk inserts
        • Parallel inserts
        • Updates
        • Testing Insert Performance
      • Optimizing SELECTs
        • Query constructs
        • Early filtering
        • Downsampling
        • CTEs vs JOINS
        • Large subsets
    • Cost optimization
      • Memory management
      • Optimizing cluster size
      • Optimizing storage
    • Monitoring and alerting
    • Automation
    • REST API
  • Support and learning
    • Resources
Powered by GitBook
On this page
  1. Drivers and integrations
  2. CrateDB CLIs (Karyn)

CrateDB shell (Crash)

Getting startedRunning CrashCommandsTroubleshootingResponse formats
PreviousCrateDB CLIs (Karyn)NextGetting started