SQLite integration

What the SQLite package does

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. It is a database, which is zero-configured, which means like other databases you do not need to configure it in your system.

Embedded SQL database package for file-based SQLite operations. Provides connection management (connect/disconnect), database creation, SQL query execution (SELECT with table results), non-query execution (INSERT/UPDATE/DELETE with affected row count), bulk table insertion with replace/ignore-conflict modes, query-to-CSV export with configurable separators, and transaction support (start/commit). SQL inputs support Mustache templating with message variables. Connections can be established via connection string or reused by connection ID. No credentials required - connects directly to local .db files.

Namespace

Robomotion.SQLite

Latest version

1.7.1 (27 versions published)

Written in

C#

Categories

Database

SQLite nodes (10)

These are the node IDs an agentic flow or an RPA bot uses, exactly as they appear in the Flow Designer and in flow code. The Toolkit node hands an agent several of the package operations at once.

Platforms

The SQLite package runs on Windows, macOS and Linux robots. Any Robomotion robot on these operating systems can run a flow that uses it.

How to install the SQLite package

1. Open Packages in the Robomotion Flow Designer.
2. Search for SQLite or Robomotion.SQLite, then click Install on its card.
3. The SQLite nodes appear in the node palette for everyone in the workspace, because installation is per workspace.

From a terminal, the Robomotion CLI installs the same package:

robomotion install Robomotion.SQLite

Templates that use SQLite

2 ready-made templates use SQLite nodes in their flows. Open one to start from a working flow.

• Clinic Support Assistant

  A customer support assistant for a website, served to the page as one MCP tool. A visitor and a signed-in patient are answered by two different Hermes Agents, and the difference is not a prompt or a flag, it is two wires: the visitor's agent is wired to the practice documents and to nothing else, so nothing on that side of the canvas can reach a patient record whatever the model is asked. The signed-in tools take no arguments at all. They read the record number the website established from a session cookie, so the model cannot name a patient, and every turn is written to a dialog log the practice can read in the morning.

• SQLite Quick Start

  Demonstrates how to use the SQLite package for database operations including creating a database, inserting rows, creating tables, and querying data.

Related integrations

Packages that share a category or keywords with SQLite. It is filed under Database.

• MySQLMySQL (an open source relational database management system) package for performing database operations such as execute query or non queries.
• OracleOracle (Oracle Database is an object-relational database management system developed and marketed by Oracle Corporation) package for performing database operations such as execute query or non queries.
• AirtableConnects to Airtable for CRUD operations on Airtable records. Supports listing bases, getting schema, bulk operations, comments, and formula-based search.
• BadgerDBBadgerDB is an embeddable, persistent and fast key-value (KV) database.
• BaserowConnect to Baserow and manage rows, tables, and fields. Baserow is an open-source no-code database platform.
• Bika AIConnect to Bika AI and manage spaces, database records, and attachments

SQLite documentation

The SQLite package reference on docs.robomotion.io documents each node and its properties.