SQL Server and PostgreSQL integration for construction
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)
See your SQL database tables in Claude — book a 30-minute call.
Supported resources
Section titled “Supported resources”Resources are discovered dynamically - each table in the target schema becomes a fetchable resource.
| Resource | FETCH | LOOKUP |
|---|---|---|
| Per-table (dynamic) | ✓ Yes | ✓ Yes |
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.
Integration model
Section titled “Integration model”The adapter builds a SQLAlchemy engine from the connection string and inspects the database schema to discover tables and views. Each table or view becomes a fetchable resource; nothing is declared in advance.
FETCH runs a SELECT with a configurable row limit (default 100). LOOKUP retrieves rows matching a single column/value pair. Relationships between tables are not modelled - joins are expressed in the workflow, not the connector.
Connection setup
Section titled “Connection setup”Required values:
- Dialect -
postgresqlormssql - Host
- Port
- Username
- Password
- Database
- Schema (optional) - defaults to
publicfor PostgreSQL
Security
Section titled “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
Section titled “Next steps”- Connecting a System - step-by-step wizard for setting up the connector
- SFTP - file-based data source alternative
- MCP Server - query SQL data through Claude once connected
- Connect your operation - talk to us about connecting it on Baseline
Talk to the team
Tell us what you run - your ERP, field, payroll and document systems - and we will show you the registers Demiton would fill from them, on your data, in a 30-minute call.