Database Plugin for LM Studio — Natural Language SQL for Local & Remote Databases

Keywords: lm studio plugin, natural language sql, local database ai, sqlite ai, postgres ai, text to sql, database explorer, no cloud, private database access

Natural language database access for LM Studio. Query SQLite and Postgres databases in plain English — inspect schemas, sample tables, run SQL, and explore your data without leaving the chat. Read-only by default; write operations opt-in.

What It Does

SQL queries — run SELECT statements (and optionally INSERT/UPDATE/DELETE) against SQLite or Postgres
Schema inspection — list tables and view column definitions
Data sampling — preview the first rows of any table
Write protection — all write operations blocked unless explicitly enabled in settings
Result truncation — large result sets truncated to configured row limit

Who This Is For

Developers who want to query local databases without switching to a separate SQL client
Data analysts who want natural language answers from their data without writing SQL manually
Anyone with a SQLite or Postgres database who wants text-to-SQL with no cloud, no data leaving the machine
Teams exploring unfamiliar databases who want schema discovery in plain English

Installation

Load the built plugin folder in LM Studio.

Configuration

Field	Default	Description
SQLite Database Path	(blank)	Absolute path to a `.db` or `.sqlite` file
Postgres Connection String	(blank)	e.g. `postgresql://user:pass@localhost:5432/mydb`
Allow Write Queries	`false`	Enable INSERT, UPDATE, DELETE, CREATE, DROP — modifies your database
Max Result Rows	`200`	Truncate query results to this many rows

Warning: Enable write queries only if you trust the model and the queries being run. There is no undo.

Tool: `database`

Single tool with four actions.

`query`

Run a SQL statement.

Write statements (INSERT, UPDATE, DELETE, DROP, etc.) are blocked unless Allow Write Queries is enabled.

`tables`

List all tables in the database.

`schema`

Show columns, types, nullability, and primary key info for a table.

`sample`

Show the first 10 rows of a table.

Shared parameters:

db_type — sqlite (default) or postgres
— path to SQLite file (overrides config)

Example Workflows

Explore an unfamiliar database:

"What tables are in this database and what does each one look like?" → database(action="tables") then database(action="schema", table="...") per table

Answer a data question:

"How many orders were placed in the last 30 days?" → database(action="query", sql="SELECT count(*) FROM orders WHERE created_at >= date('now','-30 days')")

Sample before querying:

"Show me a few rows from the products table" → database(action="sample", table="products")

Postgres:

"Connect to my Postgres database and show the schema for the payments table" → database(action="schema", db_type="postgres", table="payments")

Security Notes

Write queries are blocked by default via a regex pattern matching INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, TRUNCATE, and REPLACE
The connection string / database path is stored in plugin config and never sent to external services
Results are truncated at Max Result Rows — raw database dumps are not possible unless the limit is raised

database