Engines

What each database engine supports in SQL Explorer, and the fields its connection dialog asks for. Every engine is a provider plugin: four ship with the app, four install from the Plugin Store.

Fields marked advanced are folded away in the connection dialog until you open the advanced section — the defaults work against a stock local server.

PostgreSQL

Browse databases, schemas, tables, views, routines and triggers; run SQL with paging; create, alter and drop objects; and manage users and roles.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`5432`
`Database`	`postgres`	Required.
`Username`	`postgres`	Required.
`Password`	—	Stored in the OS keychain.
`SSL mode`	`Prefer`	Advanced. Disable / Allow / Prefer / Require / VerifyCA / VerifyFull.

MySQL / MariaDB

Browse databases, tables, views and routines; run SQL with paging; create, alter and drop objects; and manage users.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`3306`
`Database`	—	Required.
`Username`	`root`	Required.
`Password`	—	Stored in the OS keychain.

SQL Server

Browse databases and schemas, run T-SQL with paging, create, alter and drop objects, and manage server-level logins. Leave Database blank to connect at server level and browse every database from the tree — each query repoints the catalog when it runs.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`1433`
`Database`	`master`	Optional — blank connects at server level.
`Username`	`sa`	Required.
`Password`	—	Stored in the OS keychain.
`Encrypt`	`Optional`	Advanced. Optional / Mandatory / Strict.
`Trust server certificate`	`true`	Advanced — so a fresh local server with a self-signed certificate still connects.
`Application name`	`SQL Explorer`	Advanced — what the server logs as the client.
`Connect / command timeout`	—	Advanced, in seconds.

SQLite

Open a local database file: browse tables, views, indexes and triggers, run SQL, and create, alter and drop objects. No server, no credentials — and so no user management.

Field	Default	Notes
`Database file`	—	Required — a file picker.

MongoDB

Browse databases and collections, run find and aggregate queries from a JSON filter box, sort and page results, and drop or truncate collections. A document store, so the SQL-side DDL and user management do not apply.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`27017`
`Username` / `Password`	—	Optional — leave blank for an unauthenticated local server.
`Auth database`	`admin`	Advanced.
`Connection URI`	—	Advanced — a full `mongodb://` or `mongodb+srv://` URI for replica sets and Atlas. Overrides every field above.

Redis

Browse database indices and keys grouped by their : prefix, run typed commands (GET, HGETALL, SET, LPUSH, ZRANGE…) and edit Hash fields straight from the grid.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`6379`
`Password`	—	Stored in the OS keychain.
`Database index`	`0`	Advanced.
`Use TLS`	off	Advanced.

DragonflyDB

A RESP-compatible Redis drop-in, so it behaves exactly like the Redis provider above — same key browser, same typed commands, same Hash editing — against a Dragonfly server.

Field	Default	Notes
`Host`	`localhost`	Required.
`Port`	`6379`
`Password`	—	Stored in the OS keychain.
`Database index`	`0`	Advanced.
`Use TLS`	off	Advanced.

Elasticsearch

Browse indices and run Kibana Dev-Tools-style requests — _search, _cat, _count, _bulk — then edit documents in a hybrid grid.

Field	Default	Notes
`URL`	`https://localhost:9200`	Required.
`Username` / `Password`	—	Optional.
`API key`	—	Advanced — a base64 API key; takes precedence over username/password.
`Verify TLS certificate`	`true`	Advanced.
`Max field length (chars)`	`2000`	Advanced — truncates long text/JSON cells in results so a wide query over logs doesn't return hundreds of KB. Display only; the stored document is untouched.
`Time zone for date ranges`	—	Advanced — injected into date range and histogram clauses that lack one. Blank uses the app's local offset.

Another engine

Anything else can be added as a provider plugin: a folder with a manifest and an assembly that references only SqlExplorer.Sdk. See the plugin SDK guide.