Community.SQLite.Activities 1.1.6

Community.SQLite.Activities

SQLite activities for UiPath — embed a lightweight database directly into your automation workflows.

What Is This?

Community.SQLite.Activities is a free UiPath activity library that lets you work with SQLite databases directly inside your workflows — no server, no setup, no extra infrastructure.

SQLite is a lightweight, file-based database engine. This library wraps it into clean, easy-to-use UiPath activities so you can store, query, and manage data locally as part of your automation.

Why Use This?

Activities

Key Features

• Scope or Manual Mode — Use SQLiteConnect as a scope container, or get a connection variable and manage it yourself across branches, loops, and parallel flows.
• Password Encryption — Protect your database with a password. Encrypted databases are opened securely; unencrypted ones stay unencrypted unless you choose otherwise.
• In-Memory Databases — Use :memory: as the path for fast, temporary databases that exist only during the workflow run.
• Automatic Versioning — Versioned with GitVersion and Conventional Commits for predictable, semantic releases.

Installation

From UiPath Studio

1. Open Manage Packages in UiPath Studio.
2. Add a custom NuGet feed pointing to the package location.
3. Search for Community.SQLite.Activities.
4. Click Install.

From NuGet CLI

nuget install Community.SQLite.Activities

Quick Start

Scope Mode

SQLiteConnect
├── DatabasePath : "C:\data\mybot.db"
├── Use as Scope : Yes
└── Do
    ├── ExecuteQuery
    │   ├── Query   : "SELECT * FROM Orders"
    │   └── DataTable (Out) : dtOrders
    └── ExecuteNonQuery
        └── Query : "UPDATE Orders SET Status = 'Done' WHERE Id = 1"

Manual Mode

SQLiteConnect
├── DatabasePath      : "C:\data\mybot.db"
├── Use as Scope      : No
└── Connection (Out)  : dbConnection

[Your logic here — branches, loops, parallel]

ExecuteQuery
├── Connection : dbConnection
├── Query      : "SELECT * FROM Orders"
└── DataTable (Out) : dtOrders

SQLiteDisconnect
└── Connection : dbConnection

With Password

SQLiteConnect
├── DatabasePath : "C:\data\secure.db"
├── Password     : "mySecretPassword"
└── Use as Scope : Yes

Requirements

License

Freeware — Free to use for personal and commercial purposes. Source code is not publicly available.

Copyright © 2026 Ashish. All Rights Reserved.

Author

Made with ❤️ by Ashish

Feedback & Issues

Found a bug or have a feature request?

Connect on LinkedIn — always happy to hear feedback from the community.