SQLite

Category: SQL Status: good

Connects to a local SQLite database file. No server required — the database is a single file on disk.

Connection Settings

Field	Default	Description
path	(empty)	Absolute path to the .db or .sqlite file

Authentication

No authentication. Access is controlled by filesystem permissions on the database file.

Supported Actions

• execute — run SQL queries
• download — export table data
• delete — drop tables
• drawing_nodes — visualize table relationships
• rename_table — rename a table
• transfer_table — copy table to another connector
• stream_table — stream table data
• python_description / django_description / sqlalchemy_description — generate ORM model code
• generate_ddl — generate CREATE TABLE DDL

External Links

• https://www.sqlite.org/docs.html