Skip to content

SQL Compatible Sensor

Overview

Subscription

This sensor is only available with Entreprise subscriptions

The SQL Compatible Sensor in Onagre allows users to monitor database connectivity and validate query results. This sensor ensures that a database is accessible and that specific data conditions are met based on user-defined queries.

Configuration Options

When setting up an SQL Compatible Sensor, the following parameters can be configured:

  • Database Type: Specifies the type of database type (e.g., PostgreSQL, MariaDB, MySQL, SQL Server, Oracle). It is inherited from agent configuration.
  • Query Execution Mode:
    • Connectivity Check: Ensures the database connection is valid.
    • Custom SQL Query: Executes a user-defined SQL query to validate a specific data condition.
  • Query (for custom SQL mode): The SQL statement to be executed.
  • Validation Condition: Defines how the query result is evaluated (e.g., result equals a value, greater/less than, contains a substring).
  • Check Interval: Defines how often the database should be checked (e.g., every minute, every five minutes).

Response Validation

The SQL Compatible Sensor validates responses based on:

  • Successful Database Connection: Ensures the database is reachable.
  • Query Execution: Confirms that the query runs without errors.
  • Result Validation: Compares the query result against the expected value or condition.

Alerts and Notifications

If the sensor detects an issue, such as connection failure, query execution errors, or unexpected results, it can trigger alerts via:

  • Slack, Microsoft Teams, Discord, Google Chat, Webhooks, Pushover
  • Email Notifications
  • Onagre’s Dashboard for Incident Tracking

Use Cases

  • Monitoring database availability and connection health.
  • Ensuring key business metrics in a database remain within expected thresholds.
  • Validating the presence of critical records or values in a database.
  • Detecting anomalies in database queries that indicate system issues.

Deployment

The SQL Compatible Sensor operates within Onagre’s private agent framework, allowing queries to be executed securely within internal network environments where databases are hosted.

Summary

The SQL Compatible Sensor provides real-time monitoring of database connectivity and query execution, helping teams ensure the availability and integrity of critical data. By integrating with alerting tools, it enables proactive database supervision and issue resolution.