Skip to end of metadata
Go to start of metadata


Author: Kyobong An

Primary Features

The SQLite plugin has features to operate SQLite RDBMS. You can learn more about SQLite at The plugin can take SQL statement(s) either directly or via file.

Special Notes

When inputting a series of SQL statements from a file, it is recommended to separate ‘one way’ statements such as INSERT INTO from ‘two-way’ statements such as SELECT.


How to install SQLite

See below for 'step by step' instruction

Need help?

Technical contact to

May you search all operations,

Input (Requirements)

  • DB file (file path) --- file extension is .db
  • SQL statement(s)
    • Single statement
    • Statement(s) in file --- file extension is .sql


Input (Optional)

  • CSV file (file path) for bulk input
  • Number of lines (rows) to be excluded as they contain header(s)
  • Encoding format of the CSV file


Output – Return Value

This plugin returns value depending on the SQL statement.

Statements such as INSERT INTO and DELETE will return 2 lines like below. (it takes a format of one-column CSV file)



SELECT statement will return regular CSV file depending on the SQL statement’s parameters

The Return Value can be stored in


CSV (Internal memory to PAM)

File (either .txt or .csv)

Parameter Setting Examples

  • Using string for SQL and returning csv with SELECT statement

  • Using file for SQL and csv for input

  • SQL file Examples

How to install SQLite

Step 1

Step 2

  • Execute DB and Create a New Database
    * Check Desktop if DB cannot be found in Program Menu

Step 3

  • Create a Table
    * Set a table name, field names and types

Step 4

  • Input Data and Save
    * Click Browse Data and Input Data

  • Save File

Return Code

0Execution successful
9Execution failed