Skip to content
Kaisoft Docs

Data Sources

Kaisoft connects to your existing databases, MQTT brokers, and OPC-UA servers. No data migration needed — query your data where it lives.

Supported data sources

Section titled “Supported data sources”
SourceTypeDescription
PostgreSQLSQLFull support including schema discovery, query execution, and real-time monitoring
MySQLSQLMySQL 8.x and MariaDB instances
SQL ServerSQLMicrosoft SQL Server 2019+ with Windows and SQL authentication
SQLiteSQLLocal SQLite database files for lightweight data storage
DuckDBSQLEmbedded analytical database — Kaisoft uses this internally for time-series data
MQTTIoTAny MQTT 3.1.1/5.0 broker with full Sparkplug B support
OPC-UAIoTOPC Unified Architecture servers for industrial automation data

For MQTT and OPC-UA setup, see the dedicated guides: MQTT Integration and OPC-UA Integration.

Adding a SQL database

Section titled “Adding a SQL database”

Step-by-step:

  1. Click Data Sources in the sidebar navigation.
  2. Click Add Connection.
  3. Select your database type (PostgreSQL, MySQL, SQL Server, SQLite, or DuckDB).
  4. Enter connection details:
    • Host — The database server hostname or IP address
    • Port — The database port (e.g., 5432 for PostgreSQL, 3306 for MySQL)
    • Database — The database name
    • Username — Your database user
    • Password — Your database password
  5. Click Test Connection to verify the connection works.
  6. Click Save to store the connection.

Once connected, Kaisoft auto-discovers your tables and schemas. You can browse them in the Data Sources explorer, and Kai can query them automatically.

Tip: If the database is on your host machine and Kaisoft is running in Docker, use host.docker.internal instead of localhost as the host.

Editing a connection

Section titled “Editing a connection”
  1. Navigate to Data Sources in the sidebar.
  2. Find the connection you want to edit.
  3. Click the Edit button on the connection card.
  4. Update the fields as needed.
  5. Click Test Connection to verify.
  6. Click Save.

Removing a connection

Section titled “Removing a connection”
  1. Navigate to Data Sources in the sidebar.
  2. Find the connection you want to remove.
  3. Click the Delete button on the connection card.
  4. Confirm the deletion.

Note: Removing a connection does not delete your data. It only removes the connection configuration from Kaisoft.

Connection status indicators

Section titled “Connection status indicators”

Each connection in the Data Sources explorer shows a status indicator:

StatusIndicatorMeaning
Online🟢 GreenConnected and responding to queries
Offline🔴 RedCannot reach the database server
Connecting🟡 YellowAttempting to establish connection

Auto-discovery

Section titled “Auto-discovery”

If your data sources are running as Docker containers on the same network, Kaisoft can discover them automatically. Ask Kai:

Scan for available data sources

Kaisoft will scan running Docker containers and identify databases, MQTT brokers, and other services with their connection details.

Managing connections

Section titled “Managing connections”

All connections are managed in the app — go to Data Sources in the sidebar to edit, test, or remove them. Credentials you enter are stored encrypted; they’re never written to plain-text config files.

Next steps

Section titled “Next steps”