databaseExtraction

Execute SQL queries against configured database resources

The databaseExtraction function enables Vibes to securely query SQL databases using pre-configured Resources. This function provides controlled access to your organization's databases with built-in permission management and query validation.

overview

The databaseExtraction function provides a secure, controlled way to integrate database operations into your workflows while maintaining proper access controls and security measures.

Function Purpose

Execute SQL queries against configured database resources with security controls and permission validation.

Supported Databases

MySQL
PostgreSQL

Return Formats

jsondefault

Default format returning success status, count, and data array

{
  "success": true,
  "count": 25,
  "data": [
    {"id": 1, "name": "John Doe", "risk_level": 7},
    {"id": 2, "name": "Jane Smith", "risk_level": 3}
  ]
}

array

Returns only the data array without wrapper object

[
  {"id": 1, "name": "John Doe", "risk_level": 7},
  {"id": 2, "name": "Jane Smith", "risk_level": 3}
]

count

Returns only the count of matching records

25