feat(resources): implement DatabaseResource generic type with connection string support #10137

Open
opened 2026-04-17 03:55:51 +00:00 by HAL9000 · 0 comments
Owner

Background

A generic DatabaseResource type provides a provider-agnostic way to represent database connections in project configurations. This enables actors to query and modify databases without needing cloud-provider-specific resource types, supporting PostgreSQL, MySQL, SQLite, and other databases via standard connection strings.

Acceptance Criteria

  • DatabaseResource dataclass implemented with connection string and schema fields
  • Supports PostgreSQL, MySQL, and SQLite connection string formats
  • DatabaseResourceHandler implements read (query), write (execute), and list (tables) operations
  • Connection pooling managed safely with proper cleanup
  • Test coverage >= 97%

Metadata

  • Commit Message: feat(resources): implement DatabaseResource generic type with connection string support
  • Branch: feature/v3.6.0/database-resource-type
  • Milestone: v3.6.0
  • Ref: #5176 EPIC: Extended Resource Types — Cloud Infrastructure, Database & Virtual Resources (v3.6.0)

Subtasks

  • Define DatabaseResource dataclass and YAML schema
  • Implement connection string parsing for PostgreSQL, MySQL, SQLite
  • Implement DatabaseResourceHandler with query/execute/list operations
  • Implement connection pool management and cleanup
  • Write unit tests with in-memory SQLite database

Definition of Done

  • Implementation complete and all acceptance criteria met
  • Tests written and passing (coverage >= 97%)
  • PR reviewed and merged
  • Parent epic updated

Automated by CleverAgents Bot
Supervisor: Epic Planning | Agent: epic-planning-pool-supervisor

## Background A generic `DatabaseResource` type provides a provider-agnostic way to represent database connections in project configurations. This enables actors to query and modify databases without needing cloud-provider-specific resource types, supporting PostgreSQL, MySQL, SQLite, and other databases via standard connection strings. ## Acceptance Criteria - [ ] `DatabaseResource` dataclass implemented with connection string and schema fields - [ ] Supports PostgreSQL, MySQL, and SQLite connection string formats - [ ] `DatabaseResourceHandler` implements read (query), write (execute), and list (tables) operations - [ ] Connection pooling managed safely with proper cleanup - [ ] Test coverage >= 97% ## Metadata - **Commit Message**: `feat(resources): implement DatabaseResource generic type with connection string support` - **Branch**: `feature/v3.6.0/database-resource-type` - **Milestone**: v3.6.0 - **Ref**: #5176 EPIC: Extended Resource Types — Cloud Infrastructure, Database & Virtual Resources (v3.6.0) ## Subtasks - [ ] Define `DatabaseResource` dataclass and YAML schema - [ ] Implement connection string parsing for PostgreSQL, MySQL, SQLite - [ ] Implement `DatabaseResourceHandler` with query/execute/list operations - [ ] Implement connection pool management and cleanup - [ ] Write unit tests with in-memory SQLite database ## Definition of Done - Implementation complete and all acceptance criteria met - Tests written and passing (coverage >= 97%) - PR reviewed and merged - Parent epic updated --- **Automated by CleverAgents Bot** Supervisor: Epic Planning | Agent: epic-planning-pool-supervisor
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
cleveragents/cleveragents-core#10137
No description provided.