Skip to main content

RelationalDB Dataset

Overview​

RelationalDB Dataset provides structured access to relational database data, enabling querying, manipulation, and analysis of tables, columns, and relationships.

Input​

  • Database connection parameters (host, port, credentials, database name)
  • SQL queries or table selections
  • Optional filters or join specifications

Output​

  • Structured tabular data
  • Metadata including table schemas, column types, primary and foreign keys
  • Query results in standard formats (e.g., JSON, CSV, or DataFrame)

Capabilities​

  • Execute SQL queries and return results
  • Inspect database schema and relationships
  • Filter, sort, and aggregate data
  • Support for joins across multiple tables

Use Cases​

  • Data analytics and reporting
  • Application backend data retrieval
  • ETL pipelines and data integration
  • Database schema exploration and validation

Behavior Notes​

  • Supports read and write operations based on permissions
  • Transactions and batch operations may be available
  • Query performance depends on database size and indexing

Limitations​

  • Requires valid database credentials
  • Dependent on database availability and network connectivity
  • Complex queries may require optimization for large datasets

Example​

Query: SELECT name, email FROM users WHERE active = 1
Output: List of active users with name and email fields

Intended Audience​

Developers, data engineers, and analysts working with relational databases for structured data access and management.