# SQLite Cloud Docs > Official documentation for SQLite Cloud, SQLite AI extensions, Dashboard, Cloud SDKs, and SQLite reference. ## Main Resources - [Documentation Home](https://docs.sqlitecloud.io): Start page for SQLite Cloud documentation. - [Sitemap](https://docs.sqlitecloud.io/sitemap-index.xml): XML sitemap with all indexable documentation pages. ## AI and Extensions - [Getting Started with SQLite AI](https://docs.sqlitecloud.io/docs/ai-overview): SQLite AI brings local AI, vector search, sync, analytics, memory, and JavaScript extensions directly into SQLite. - [Build AI Search for Your Documentation](https://docs.sqlitecloud.io/docs/aisearch-documents): SQLite AI Search for your documents and files - [AI - Model Context Protocol (MCP)](https://docs.sqlitecloud.io/docs/mcp-server): MCP Server for SQLite Cloud to interact with SQLite Cloud databases using the AI models - [SQLite-AI](https://docs.sqlitecloud.io/docs/sqlite-ai): Run LLM inference, embeddings, chat, audio transcription, and multimodal AI directly inside SQLite. - [SQLite-AI API Reference](https://docs.sqlitecloud.io/docs/sqlite-ai-api-reference): Reference for SQLite-AI SQL functions, LLM contexts, samplers, embeddings, chat, vision, and audio. - [SQLite-AI Embedding Notes](https://docs.sqlitecloud.io/docs/sqlite-ai-embedding-notes): Notes about embedding pooling, output shape, and model compatibility in SQLite-AI. - [SQLite-AI Examples](https://docs.sqlitecloud.io/docs/sqlite-ai-examples): SQLite-AI SQL examples for text generation, embeddings, chat, audio, and vision workflows. - [SQLite-AI Getting Started](https://docs.sqlitecloud.io/docs/sqlite-ai-getting-started): Run local model inference, embeddings, audio transcription, and multimodal AI from SQL. - [SQLite-Columnar](https://docs.sqlitecloud.io/docs/sqlite-columnar): Column-oriented analytics inside SQLite for fast local scans, aggregations, and grouped summaries. - [SQLite-Columnar API Reference](https://docs.sqlitecloud.io/docs/sqlite-columnar-api-reference): Reference for SQLite-Columnar virtual tables, scalar functions, and grouped table-valued functions. - [SQLite-Columnar Benchmarks](https://docs.sqlitecloud.io/docs/sqlite-columnar-benchmarks): Benchmark notes and performance results for SQLite-Columnar analytical workloads. - [SQLite-Columnar Getting Started](https://docs.sqlitecloud.io/docs/sqlite-columnar-getting-started): Query SQLite-Columnar virtual tables for embedded analytics. - [SQLite-JS](https://docs.sqlitecloud.io/docs/sqlite-js): Write SQLite scalar, aggregate, window, and collation functions in JavaScript. - [SQLite-JS API Reference](https://docs.sqlitecloud.io/docs/sqlite-js-api-reference): Reference for SQLite-JS scalar, aggregate, window, collation, eval, utility, and update functions. - [SQLite-JS Examples](https://docs.sqlitecloud.io/docs/sqlite-js-examples): SQLite-JS examples for custom SQL logic written in JavaScript. - [SQLite-JS Getting Started](https://docs.sqlitecloud.io/docs/sqlite-js-getting-started): Create custom SQLite functions with JavaScript from SQL. - [SQLite-Memory](https://docs.sqlitecloud.io/docs/sqlite-memory): Persistent, searchable memory for AI agents using SQLite, vector search, FTS5, and markdown-aware chunking. - [SQLite-Memory API Reference](https://docs.sqlitecloud.io/docs/sqlite-memory-api-reference): Reference for sqlite-memory SQL functions, search virtual table, configuration, sync, and C API. - [SQLite-Memory CLI](https://docs.sqlitecloud.io/docs/sqlite-memory-cli): sqlmem command-line workflow and examples for managing sqlite-memory projects. - [SQLite-Memory Examples](https://docs.sqlitecloud.io/docs/sqlite-memory-examples): Examples for building AI agents with persistent memory and syncing memory across agents. - [SQLite-Memory Getting Started](https://docs.sqlitecloud.io/docs/sqlite-memory-getting-started): Configure sqlite-memory, load embeddings, ingest content, and run semantic memory search. - [cloudsync_begin_alter(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-begin-alter): SQLite-Sync SQL function reference. - [cloudsync_cleanup(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-cleanup): SQLite-Sync SQL function reference. - [cloudsync_clear_filter(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-clear-filter): SQLite-Sync SQL function reference. - [cloudsync_commit_alter(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-commit-alter): SQLite-Sync SQL function reference. - [cloudsync_db_version()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-db-version): SQLite-Sync SQL function reference. - [cloudsync_disable(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-disable): SQLite-Sync SQL function reference. - [cloudsync_enable(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-enable): SQLite-Sync SQL function reference. - [cloudsync_init(table_name, [crdt_algo], [init_flags])](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-init): SQLite-Sync SQL function reference. - [cloudsync_is_enabled(table_name)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-is-enabled): SQLite-Sync SQL function reference. - [cloudsync_network_check_changes()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-check-changes): SQLite-Sync SQL function reference. - [cloudsync_network_cleanup()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-cleanup): SQLite-Sync SQL function reference. - [cloudsync_network_has_unsent_changes()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-has-unsent-changes): SQLite-Sync SQL function reference. - [cloudsync_network_init(managedDatabaseId)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-init): SQLite-Sync SQL function reference. - [cloudsync_network_logout()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-logout): SQLite-Sync SQL function reference. - [cloudsync_network_reset_sync_version()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-reset-sync-version): SQLite-Sync SQL function reference. - [cloudsync_network_send_changes()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-send-changes): SQLite-Sync SQL function reference. - [cloudsync_network_set_apikey(apikey)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-set-apikey): SQLite-Sync SQL function reference. - [cloudsync_network_set_token(token)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-set-token): SQLite-Sync SQL function reference. - [cloudsync_network_sync([wait_ms], [max_retries])](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-network-sync): SQLite-Sync SQL function reference. - [cloudsync_set_column(table_name, col_name, key, value)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-set-column): SQLite-Sync SQL function reference. - [cloudsync_set_filter(table_name, filter_expr)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-set-filter): SQLite-Sync SQL function reference. - [cloudsync_siteid()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-siteid): SQLite-Sync SQL function reference. - [cloudsync_terminate()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-terminate): SQLite-Sync SQL function reference. - [cloudsync_text_materialize(table_name, col_name, pk_values...)](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-text-materialize): SQLite-Sync SQL function reference. - [cloudsync_uuid()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-uuid): SQLite-Sync SQL function reference. - [cloudsync_version()](https://docs.sqlitecloud.io/docs/sqlite-sync-api-cloudsync-version): SQLite-Sync SQL function reference. - [Client API Reference](https://docs.sqlitecloud.io/docs/sqlite-sync-api-reference): Reference for the SQLite Sync client runtime functions for configuration, filters, block-level LWW, helpers, schema changes, and networking. - [SQLite-Sync Best Practices](https://docs.sqlitecloud.io/docs/sqlite-sync-best-practices): SQLite-Sync Best Practices - [SQLite-Sync Block-Level LWW](https://docs.sqlitecloud.io/docs/sqlite-sync-block-lww): Configure block-level last-write-wins conflict resolution for collaborative text columns in SQLite-Sync. - [Management API](https://docs.sqlitecloud.io/docs/sqlite-sync-cloudsync-management-api): Register and manage SQLite Sync databases programmatically with a workspace-admin management API key. - [SQLite-Sync Getting Started](https://docs.sqlitecloud.io/docs/sqlite-sync-getting-started): SQLite-Sync Getting Started - [SQLite-Sync Installation](https://docs.sqlitecloud.io/docs/sqlite-sync-installation): Installation options for SQLite-Sync across native, mobile, Expo, React Native, Flutter, and WASM targets. - [Introduction to SQLite-Sync](https://docs.sqlitecloud.io/docs/sqlite-sync-introduction): Introduction to SQLite-Sync - [JWT Claims Reference](https://docs.sqlitecloud.io/docs/sqlite-sync-jwt-claims): JWT claim requirements and role/grant expectations for PostgreSQL and Supabase CloudSync backends. - [Self-Hosted PostgreSQL Quick Start](https://docs.sqlitecloud.io/docs/sqlite-sync-postgresql-quick-start): Enable CloudSync on your own PostgreSQL instance and connect SQLite Sync clients to it. - [Android Quick Start Guide](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-android): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [React Native - Expo Quick Start Guide](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-expo): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [iOS Quick Start Guide](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-ios): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [Linux Quick Start](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-linux): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [MacOS Quick Start Guide](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-macos): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [WASM Quick Start Guide](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-wasm): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [Windows Quick Start](https://docs.sqlitecloud.io/docs/sqlite-sync-quick-start-windows): SQLite Sync is a multi-platform extension that brings a true local-first experience to your applications with minimal effort. - [RLS Reference](https://docs.sqlitecloud.io/docs/sqlite-sync-rls-reference): Behavior, setup, and troubleshooting for using CloudSync with PostgreSQL Row Level Security. - [SQLite-Sync Row-Level Security](https://docs.sqlitecloud.io/docs/sqlite-sync-row-level-security): Use SQLite-Sync with SQLite Cloud Row-Level Security for per-user and per-tenant data isolation. - [Self-Hosted Supabase Quick Start](https://docs.sqlitecloud.io/docs/sqlite-sync-supabase-self-hosted-quick-start): Enable CloudSync on a self-hosted Supabase deployment and connect SQLite Sync clients to it. - [SQLite-Vector](https://docs.sqlitecloud.io/docs/sqlite-vector): Production-grade vector search inside SQLite for local, edge, and embedded AI applications. - [SQLite-Vector API Reference](https://docs.sqlitecloud.io/docs/sqlite-vector-api-reference): Reference for SQLite-Vector functions, vector types, quantization, and scan APIs. - [SQLite-Vector Examples](https://docs.sqlitecloud.io/docs/sqlite-vector-examples): SQLite-Vector examples for inserting, quantizing, preloading, and searching vectors. - [SQLite-Vector Getting Started](https://docs.sqlitecloud.io/docs/sqlite-vector-getting-started): Run nearest-neighbor search from ordinary SQLite tables. - [SQLite-Vector Quantization](https://docs.sqlitecloud.io/docs/sqlite-vector-quantization): Guide to SQLite-Vector quantization for high-performance vector search. ## Cloud - [Architecture](https://docs.sqlitecloud.io/docs/architecture): SQLite Cloud Architecture - [Connecting to a Cluster](https://docs.sqlitecloud.io/docs/connect-cluster): Learn how to connect to a cluster in SQLite Cloud. - [Creating a Database](https://docs.sqlitecloud.io/docs/create-database): Learn how to import a database into SQLite Cloud. - [Getting Started with SQLite Cloud](https://docs.sqlitecloud.io/docs/overview): SQLite Cloud is a distributed relational database system built on top of the SQLite database engine. - [Apollo / GraphQL Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-apollo-graphql): Get started with SQLite Cloud using Apollo and GraphQL. - [CDN Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-cdn): Get started with SQLite Cloud using a Content Delivery Network - [Django Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-django): Get started with SQLite Cloud using Django. - [Flask Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-flask): Get started with SQLite Cloud using Flask. - [Gin Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-gin): Get started with SQLite Cloud using Gin. - [Knex.js Integration](https://docs.sqlitecloud.io/docs/quick-start-knex): Integrate SQLite Cloud with Knex.js, a popular SQL query builder. - [Next.js Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-next): Get started with SQLite Cloud using Next.js. - [Node.js Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-node): Get started with SQLite Cloud using Node.js and Express. - [PHP / Laravel Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-php-laravel): Get started with SQLite Cloud using PHP and Laravel. - [React Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-react): Get started with SQLite Cloud using React. - [React Native Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-react-native): Get started with SQLite Cloud using React Native. - [SQLAlchemy ORM Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-sqlalchemy-orm): Get started with SQLite Cloud using SQLAlchemy ORM in FastAPI. - [Streamlit Quick Start Guide](https://docs.sqlitecloud.io/docs/quick-start-streamlit): Get started with SQLite Cloud using Streamlit. - [Using SQLite Extensions - Geopoly](https://docs.sqlitecloud.io/docs/tutorial-geopoly): Build a local attractions finder app using SQLite Cloud, SQLite's built-in Geopoly extension, Mapbox, and React. - [Writing data to your database](https://docs.sqlitecloud.io/docs/write-data): Learn how to write data to your SQLite Cloud cluster. ## Dashboard - [Access Tokens](https://docs.sqlitecloud.io/docs/access-tokens): Grant to your users, devices, tenant, access to SQLite Cloud database and services. - [Query Analyzer](https://docs.sqlitecloud.io/docs/analyzer): The Analyzer panel is a powerful tool that collects and categorizes all the queries executed on your cluster based on their execution time. - [Security and Access Control](https://docs.sqlitecloud.io/docs/apikey): Manage API Keys for secure application access, server-to-server communication, and SDK integration. - [Backup](https://docs.sqlitecloud.io/docs/backups): With SQLite Cloud, you have the flexibility to restore your database from any desired point in time. - [CloudSync](https://docs.sqlitecloud.io/docs/cloudsync): Enable local-first applications with automatic data synchronization between edge devices and SQLite Cloud. - [Edge Functions](https://docs.sqlitecloud.io/docs/edge-functions): SQLite Cloud offers powerful edge functions for performant data processing and third-party integrations. - [SQLite Extensions](https://docs.sqlitecloud.io/docs/extensions): Extensions available for use in SQLite Cloud. - [Logs](https://docs.sqlitecloud.io/docs/logs): View detailed insights into your SQLite Cloud project's operations to monitor activity, debug issues, and track system behavior in real time. - [Row-Level Security](https://docs.sqlitecloud.io/docs/rls): Configure fine-grained access control policies to determine which rows in a table a user can access. - [Roles & Privileges](https://docs.sqlitecloud.io/docs/roles): Understand the role-based access control system, built-in roles, and how to define custom access policies. - [Security and Access Control](https://docs.sqlitecloud.io/docs/security): SQLite Cloud provides secure access to resources through role-based authorization, which ensures user isolation and enhances security and manageability. - [Users](https://docs.sqlitecloud.io/docs/users): Manage users, credentials, and access scopes in SQLite Cloud. - [Webhooks](https://docs.sqlitecloud.io/docs/webhooks): Utilize the Webhooks panel to effortlessly establish real-time notifications for write operations within your SQLite database. - [Weblite](https://docs.sqlitecloud.io/docs/weblite): With Weblite, adding robust database capabilities to your site is as simple as adding Google Analytics. ## Cloud SDKs - [C](https://docs.sqlitecloud.io/docs/sdk-c-introduction): SQCloud C Interface - [GO SDK Getting Started](https://docs.sqlitecloud.io/docs/sdk-go-introduction): Here's the how gettting started to use the SQLite Cloud in your Go code. - [JS SDK Introduction](https://docs.sqlitecloud.io/docs/sdk-js-introduction): SQLite Cloud Javascript SDK - [Modules](https://docs.sqlitecloud.io/docs/sdk-js-modules): SQLite Cloud Javascript SDK - [PHP SDK Getting Started](https://docs.sqlitecloud.io/docs/sdk-php-introduction): Get started with SQLite Cloud using PHP. - [PHP SDK Methods](https://docs.sqlitecloud.io/docs/sdk-php-methods): Methods available in the SQLite Cloud PHP SDK. - [Python SDK Introduction](https://docs.sqlitecloud.io/docs/sdk-python-introduction): SQLite Cloud Python SDK - [Swift SDK Introduction](https://docs.sqlitecloud.io/docs/sdk-swift-introduction): Get started with SQLite Cloud using Swift. - [SQCloudArrayCount](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarraycount): SQCloud Array C/C++ Interface SQCloudArrayCount - [SQCloudArrayDoubleValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarraydoublevalue): SQCloud Array C/C++ Interface SQCloudArrayDoubleValue - [SQCloudArrayDump](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarraydump): SQCloud Array C/C++ Interface SQCloudArrayDump - [SQCloudArrayFloatValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarrayfloatvalue): SQCloud Array C/C++ Interface SQCloudArrayFloatValue - [SQCloudArrayInt32Value](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarrayint32value): SQCloud Array C/C++ Interface SQCloudArrayInt32Value - [SQCloudArrayInt64Value](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarrayint64value): SQCloud Array C/C++ Interface SQCloudArrayInt64Value - [SQCloudArrayValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarrayvalue): SQCloud Array C/C++ Interface SQCloudArrayValue - [SQCloudArrayValueType](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudarrayvaluetype): SQCloud Array C/C++ Interface SQCloudArrayValueType - [SQCloudBlobBytes](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobbytes): SQCloud Blob C/C++ Interface SQCloudBlobBytes - [SQCloudBlobClose](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobclose): SQCloud Blob C/C++ Interface SQCloudBlobClose - [SQCloudBlobOpen](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobopen): SQCloud Blob C/C++ Interface SQCloudBlobOpen - [SQCloudBlobRead](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobread): SQCloud Blob C/C++ Interface SQCloudBlobRead - [SQCloudBlobReOpen](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobreopen): SQCloud Blob C/C++ Interface SQCloudBlobReOpen - [SQCloudBlobWrite](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudblobwrite): SQCloud Blob C/C++ Interface SQCloudBlobWrite - [SQCloudConfig](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudconfig): SQCloud Basic C/C++ Interface SQCloudConfig - [SQCloudConnect](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudconnect): SQCloud Basic C/C++ Interface SQCloudConnect - [SQCloudConnectWithString](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudconnectwithstring): SQCloud Basic C/C++ Interface SQCloudConnectWithString - [SQCloudDisconnect](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqclouddisconnect): SQCloud Basic C/C++ Interface SQCloudDisconnect - [SQCloudDownloadDatabase](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqclouddownloaddatabase): SQCloud Basic C/C++ Interface SQCloudDownloadDatabase - [Error APIs](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqclouderror): SQCloud Error API C/C++ Interface - [SQCloudExec](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudexec): SQCloud Basic C/C++ Interface SQCloudExec - [SQCloudExecArray](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudexecarray): SQCloud Basic C/C++ Interface SQCloudExecArray - [SQCloudResultDouble](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultdouble): SQCloud Basic C/C++ Interface SQCloudResultDouble - [SQCloudResultDump](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultdump): SQCloud Basic C/C++ Interface SQCloudResultDump - [SQCloudResultFloat](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultfloat): SQCloud Basic C/C++ Interface SQCloudResultFloat - [SQCloudResultFree](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultfree): SQCloud Basic C/C++ Interface SQCloudResultFree - [SQCloudResultInt32](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultint32): SQCloud Basic C/C++ Interface SQCloudResultInt32 - [SQCloudResultInt64](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultint64): SQCloud Basic C/C++ Interface SQCloudResultInt64 - [SQCloudResultIsError](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultiserror): SQCloud Basic C/C++ Interface SQCloudResultIsError - [SQCloudResultIsOK](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultisok): SQCloud Basic C/C++ Interface SQCloudResultIsOK - [SQCloudResultLen](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresultlen): SQCloud Basic C/C++ Interface SQCloudResultLen - [SQCloudResultType](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudresulttype): SQCloud Basic C/C++ Interface SQCloudResultType - [SQCloudRowsetCols](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetcols): SQCloud Rowset C/C++ Interface SQCloudRowsetCols - [SQCloudRowsetColumnName](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetcolumnname): SQCloud Rowset C/C++ Interface SQCloudRowsetColumnName - [SQCloudRowsetDoubleValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetdoublevalue): SQCloud Rowset C/C++ Interface SQCloudRowsetDoubleValue - [SQCloudRowsetDump](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetdump): SQCloud Rowset C/C++ Interface SQCloudRowsetDump - [SQCloudRowsetFloatValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetfloatvalue): SQCloud Rowset C/C++ Interface SQCloudRowsetFloatValue - [SQCloudRowsetInt32Value](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetint32value): SQCloud Rowset C/C++ Interface SQCloudRowsetInt32Value - [SQCloudRowsetInt64Value](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetint64value): SQCloud Rowset C/C++ Interface SQCloudRowsetInt64Value - [SQCloudRowsetRows](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetrows): SQCloud Rowset C/C++ Interface SQCloudRowsetRows - [SQCloudRowsetValue](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetvalue): SQCloud Rowset C/C++ Interface SQCloudRowsetValue - [SQCloudRowsetValueType](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudrowsetvaluetype): SQCloud Rowset C/C++ Interface SQCloudRowsetValueType - [SQCloudUploadDatabase](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqclouduploaddatabase): SQCloud Basic C/C++ Interface SQCloudUploadDatabase - [SQCloudUUID](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqclouduuid): SQCloud Basic C/C++ Interface SQCloudUUID - [SQCloudVMBind](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmbind): SQCloud VM C/C++ Interface SQCloudVMBind - [SQCloudVMBindParameterCount](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmbindparametercount): SQCloud VM C/C++ Interface SQCloudVMBindParameterCount - [SQCloudVMBindParameterIndex](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmbindparameterindex): SQCloud VM C/C++ Interface SQCloudVMBindParameterIndex - [SQCloudVMBindParameterName](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmbindparametername): SQCloud VM C/C++ Interface SQCloudVMBindParameterName - [SQCloudVMChanges](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmchanges): SQCloud VM C/C++ Interface SQCloudVMChanges - [SQCloudVMClose](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmclose): SQCloud VM C/C++ Interface SQCloudVMClose - [SQCloudVMColumn](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmcolumn): SQCloud VM C/C++ Interface SQCloudVMColumn - [SQCloudVMColumnCount](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmcolumncount): SQCloud VM C/C++ Interface SQCloudVMColumnCount - [SQCloudVMCompile](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmcompile): SQCloud VM C/C++ Interface SQCloudVMCompile - [SQCloudVMErrorCode](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmerrorcode): SQCloud VM C/C++ Interface SQCloudVMErrorCode - [SQCloudVMErrorMsg](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmerrormsg): SQCloud VM C/C++ Interface SQCloudVMErrorMsg - [SQCloudVMIsExplain](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmisexplain): SQCloud VM C/C++ Interface SQCloudVMIsExplain - [SQCloudVMIsFinalized](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmisfinalized): SQCloud VM C/C++ Interface SQCloudVMIsFinalized - [SQCloudVMIsReadOnly](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmisreadonly): SQCloud VM C/C++ Interface SQCloudVMIsReadOnly - [SQCloudVMLastRowID](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmlastrowid): SQCloud VM C/C++ Interface SQCloudVMLastRowID - [SQCloudVMResult](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmresult): SQCloud VM C/C++ Interface SQCloudVMResult - [SQCloudVMStep](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmstep): SQCloud VM C/C++ Interface SQCloudVMStep - [SQCloudVMTotalChanges](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/c/sqcloudvmtotalchanges): SQCloud VM C/C++ Interface SQCloudVMTotalChanges - [Database](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/database): SQLite Cloud Javascript SDK - [SQLiteCloudConnection](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/sqlitecloudconnection): SQLite Cloud Javascript SDK - [SQLiteCloudError](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/sqliteclouderror): SQLite Cloud Javascript SDK - [SQLiteCloudRow](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/sqlitecloudrow): SQLite Cloud Javascript SDK - [SQLiteCloudRowset](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/sqlitecloudrowset): SQLite Cloud Javascript SDK - [Statement T](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/classes/statement): SQLite Cloud Javascript SDK - [SQLCloudRowsetMetadata](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/interfaces/sqlcloudrowsetmetadata): SQLite Cloud Javascript SDK - [SQLiteCloudConfig](https://docs.sqlitecloud.io/docs/sqlite-cloud/sdks/js/interfaces/sqlitecloudconfig): SQLite Cloud Javascript SDK ## Reference - [API Key Commands](https://docs.sqlitecloud.io/docs/api-key-commands): Learn about APIKEY commands in SQLite Cloud. - [Auth Commands](https://docs.sqlitecloud.io/docs/auth-commands): The AUTH command authenticates the current connection, without authentication the connection cannot send any other command to the server - [Backup Commands](https://docs.sqlitecloud.io/docs/backup-commands): Backup-related commands in SQLite Cloud - [Command Line Interface](https://docs.sqlitecloud.io/docs/cli-commands): The SQLite Cloud Command Line Interface is a user-friendly interface that runs on the terminal and acts as a front-end to SQLite Cloud. - [Cluster Commands](https://docs.sqlitecloud.io/docs/cluster-commands): Cluster commands are used to manage the cluster environment, such as listing nodes, getting the leader node, and transferring leadership to a specific node. - [Database Commands](https://docs.sqlitecloud.io/docs/database-commands): Database commands are used to manage databases, such as creating, removing, and listing databases. - [General Info Commands](https://docs.sqlitecloud.io/docs/general-commands): These commands provide general information about the server, such as the version, the number of databases, and the number of active connections. - [IP Commands](https://docs.sqlitecloud.io/docs/ip-commands): IP commands are used to manage the IP restrictions for users and roles. - [Log Commands](https://docs.sqlitecloud.io/docs/log-commands): Log commands are used to retrieve the logs generated on the server side. - [Plugin Commands](https://docs.sqlitecloud.io/docs/plugin-commands): Use these commands to manage the SQLite Cloud plugins. - [Privilege Commands](https://docs.sqlitecloud.io/docs/privilege-commands): Use these commands to manage privileges in SQLite Cloud. - [Query Analyzer Commands](https://docs.sqlitecloud.io/docs/query-analyzer-commands): These commands are used to analyze the performance of queries executed on the server. - [Role Commands](https://docs.sqlitecloud.io/docs/role-commands): Role commands allow you to manage roles in SQLite Cloud. - [Server-side Commands - SQLite Cloud](https://docs.sqlitecloud.io/docs/server-side-commands): Learn about the server side commands in SQLite Cloud. - [Settings Commands](https://docs.sqlitecloud.io/docs/settings-commands): Settings commands are used to manage settings in SQLite Cloud. - [SQLite Getting Started](https://docs.sqlitecloud.io/docs/sqlite): Getting started with interactive SQLite documentation, where we bring learning to life with an innovative and interactive feature. - [JSON Functions And Operators](https://docs.sqlitecloud.io/docs/sqlite/json1): By default, SQLite supports twenty-nine functions and two operators for dealing with JSON values. - [Built-in Aggregate Functions](https://docs.sqlitecloud.io/docs/sqlite/lang_aggfunc): The aggregate functions shown below are available by default. There are two more aggregates grouped with the JSON SQL functions. - [ALTER TABLE](https://docs.sqlitecloud.io/docs/sqlite/lang_altertable): SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows these alterations of an existing table. - [ANALYZE](https://docs.sqlitecloud.io/docs/sqlite/lang_analyze): The ANALYZE command gathers statistics about tables and indices and stores the collected information in internal tables. - [ATTACH DATABASE](https://docs.sqlitecloud.io/docs/sqlite/lang_attach): The ATTACH DATABASE statement adds another database file to the current database connection. - [SQL Comment Syntax](https://docs.sqlitecloud.io/docs/sqlite/lang_comment): Comments are not SQL commands, but can occur within the text of SQL queries passed to sqlite3_prepare_v2() and related interfaces. - [The ON CONFLICT Clause](https://docs.sqlitecloud.io/docs/sqlite/lang_conflict): The ON CONFLICT clause is a non-standard extension specific to SQLite that can appear in many other SQL commands. - [Built-In Scalar SQL Functions](https://docs.sqlitecloud.io/docs/sqlite/lang_corefunc): The core functions shown below are available by default. Date & Time functions, aggregate functions, window functions, math functions, and JSON functions. - [CREATE INDEX](https://docs.sqlitecloud.io/docs/sqlite/lang_createindex): The CREATE INDEX command consists of the keywords "CREATE INDEX" followed by the name of the new index. - [CREATE TABLE](https://docs.sqlitecloud.io/docs/sqlite/lang_createtable): The "CREATE TABLE" command is used to create a new table in an SQLite database. - [CREATE TRIGGER](https://docs.sqlitecloud.io/docs/sqlite/lang_createtrigger): The CREATE TRIGGER statement is used to add triggers to the database schema. - [CREATE VIEW](https://docs.sqlitecloud.io/docs/sqlite/lang_createview): The CREATE VIEW command assigns a name to a pre-packaged SELECT statement. - [CREATE VIRTUAL TABLE](https://docs.sqlitecloud.io/docs/sqlite/lang_createvtab): A virtual table is an interface to an external storage or computation engine that appears to be a table but does not actually store information in the database file. - [Date And Time Functions](https://docs.sqlitecloud.io/docs/sqlite/lang_datefunc): SQLite supports seven scalar date and time functions as follows in this page - [DELETE](https://docs.sqlitecloud.io/docs/sqlite/lang_delete): The DELETE command removes records from the table identified by the qualified-table-name. - [DETACH](https://docs.sqlitecloud.io/docs/sqlite/lang_detach): This statement detaches an additional database connection previously attached using the ATTACH statement. - [DROP INDEX](https://docs.sqlitecloud.io/docs/sqlite/lang_dropindex): The DROP INDEX statement removes an index added with the CREATE INDEX statement. - [DROP TABLE](https://docs.sqlitecloud.io/docs/sqlite/lang_droptable): The DROP TABLE statement removes a table added with the CREATE TABLE statement. - [DROP TRIGGER](https://docs.sqlitecloud.io/docs/sqlite/lang_droptrigger): The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. - [DROP VIEW](https://docs.sqlitecloud.io/docs/sqlite/lang_dropview): The DROP VIEW statement removes a view created by the CREATE VIEW statement. - [EXPLAIN](https://docs.sqlitecloud.io/docs/sqlite/lang_explain): An SQL statement can be preceded by the keyword "EXPLAIN" or by the phrase "EXPLAIN QUERY PLAN". - [SQL Language Expressions](https://docs.sqlitecloud.io/docs/sqlite/lang_expr): SQLite understands various operators, listed in this page of the SQLite Cloud Docs. - [The INDEXED BY Clause](https://docs.sqlitecloud.io/docs/sqlite/lang_indexedby): The INDEXED BY phrase forces the SQLite query planner to use a particular named index on a DELETE, SELECT, or UPDATE statement. - [INSERT](https://docs.sqlitecloud.io/docs/sqlite/lang_insert): The INSERT statement comes in three basic forms. INSERT INTO table VALUES(...); INSERT INTO table SELECT ...; INSERT INTO table DEFAULT VALUES; - [SQLite Keywords](https://docs.sqlitecloud.io/docs/sqlite/lang_keywords): The SQL standard specifies a large number of keywords which may not be used as the names of any named object. - [Built-In Mathematical SQL Functions](https://docs.sqlitecloud.io/docs/sqlite/lang_mathfunc): The math functions shown below are a subgroup of scalar functions that are built into the SQLite amalgamation source file. - [Database Object Name Resolution](https://docs.sqlitecloud.io/docs/sqlite/lang_naming): In SQLite, a database object (a table, index, trigger or view) is identified by the name of the object and the name of the database that it resides in. - [REINDEX](https://docs.sqlitecloud.io/docs/sqlite/lang_reindex): The REINDEX command is used to delete and recreate indices from scratch. - [REPLACE](https://docs.sqlitecloud.io/docs/sqlite/lang_replace): The REPLACE command is an alias for the "INSERT OR REPLACE" variant of the INSERT command. - [RETURNING](https://docs.sqlitecloud.io/docs/sqlite/lang_returning): The RETURNING clause is not a statement itself, but a clause that can optionally appear near the end of top-level DELETE, INSERT, and UPDATE statements. - [Savepoints](https://docs.sqlitecloud.io/docs/sqlite/lang_savepoint): SAVEPOINTs are a method of creating transactions, similar to BEGIN and COMMIT. - [SELECT](https://docs.sqlitecloud.io/docs/sqlite/lang_select): The SELECT statement is used to query the database. The result of a SELECT is zero or more rows of data where each row has a fixed number of columns. - [Transaction](https://docs.sqlitecloud.io/docs/sqlite/lang_transaction): Any command that accesses the database will automatically start a transaction if one is not already in effect. - [UPDATE](https://docs.sqlitecloud.io/docs/sqlite/lang_update): An UPDATE statement is used to modify a subset of the values stored in zero or more rows of the database table. - [UPSERT](https://docs.sqlitecloud.io/docs/sqlite/lang_upsert): UPSERT is a clause added to INSERT that causes the INSERT to behave as an UPDATE or a no-op if the INSERT would violate a uniqueness constraint. - [VACUUM](https://docs.sqlitecloud.io/docs/sqlite/lang_vacuum): The VACUUM command rebuilds the database file, repacking it into a minimal amount of disk space. - [The WITH Clause](https://docs.sqlitecloud.io/docs/sqlite/lang_with): Common Table Expressions or CTEs act like temporary views that exist only for the duration of a single SQL statement. - [User Commands](https://docs.sqlitecloud.io/docs/user-commands): Use these commands to manage the SQLite Cloud users.