Skip to content
Demiton

SQL Database

Stable Connected tier

Generic SQL connector for querying relational databases. Tables are discovered dynamically from the database schema. Supports PostgreSQL and Microsoft SQL Server.

Authentication: Connection string (dialect, host, port, username, password, database)
Connection type: SQL
Supported dialects: PostgreSQL (postgresql+psycopg2), SQL Server (mssql+pyodbc)

Supported resources

Resources are discovered dynamically - each table in the target schema becomes a fetchable resource.

ResourceFETCHLOOKUP
Per-table (dynamic)✓✓

FETCH runs SELECT * with a configurable row limit (default 100). LOOKUP retrieves rows matching a specific column/value pair.

This connector is read-only - write and execute operations are not supported.

Connection setup

Required values:

  • Dialect - postgresql or mssql
  • Host
  • Port
  • Username
  • Password
  • Database
  • Schema (optional) - defaults to public for PostgreSQL

Security

Access type: Read-only

Demiton queries your database using the credentials provided. No data is written.

Permissions required: A database user with SELECT access on the specific tables or views your workflows query. Do not use an admin or owner account - create a dedicated read-only user for Demiton.

Best practice: Connect Demiton to a read replica if one is available, to avoid any impact on production database performance.

Next steps