---
title: "Insert"
description: "Local-first visual environment for building and running AI workflows. Build agents visually, deploy anywhere, privacy by design."
canonical: https://docs.nodetool.ai/nodes/lib/sqlite/insert
markdown: https://docs.nodetool.ai/nodes/lib/sqlite/insert.md
product: NodeTool
source: https://github.com/nodetool-ai/nodetool/blob/main/docs/nodes/lib/sqlite/insert.md
---

# Insert

**Type:** `lib.sqlite.Insert`

**Namespace:** `lib.sqlite`

## Description

Insert a record into a SQLite table.
    sqlite, database, insert, add, record

    Use cases:
    - Add new flashcards to database
    - Store agent observations
    - Persist workflow results

## Properties

| Property | Type | Description | Default |
|----------|------|-------------|---------|
| database_name | `str` | Name of the SQLite database file | `memory.db` |
| table_name | `str` | Name of the table to insert into | `flashcards` |
| data | `dict[str, any]` | Data to insert as dict (column: value) | `{"content":"example"}` |

## Outputs

| Output | Type | Description |
|--------|------|-------------|
| row_id | `int` |  |
| rows_affected | `int` |  |
| message | `str` |  |

## Related Nodes

Browse other nodes in the [lib.sqlite](./) namespace.