> ## Documentation Index
> Fetch the complete documentation index at: https://docs.moonly.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# List database transactions

> Returns paginated list of database transactions with filtering options.



## OpenAPI

````yaml openapi.json get /transactions
openapi: 3.0.0
info:
  title: Aurora Database API
  description: >-
    Comprehensive database management API providing dynamic database
    connections, real-time table operations, advanced querying, and transaction
    logging. Supports both managed PostgreSQL databases and external database
    connections with full CRUD operations.
  contact:
    name: Aurora Development Team
    email: support@aurora.com
  license:
    name: MIT
    url: https://opensource.org/licenses/MIT
  version: '1.0'
servers:
  - url: /api
    description: Aurora API Server
security:
  - sanctum: []
tags:
  - name: Database Management
    description: >-
      🗄️ **Create, manage, and connect databases** - Start here to set up your
      PostgreSQL databases or connect to existing ones. These endpoints let you
      create managed databases, test connections, and handle basic database
      operations.
  - name: Table Operations
    description: >-
      📊 **Design your data structure** - Build and manage tables within your
      databases. Create tables with custom names, get table information, and
      organize your data structure exactly how you need it.
  - name: Column Management
    description: >-
      🏗️ **Define your data fields** - Add columns to your tables with various
      data types like text, numbers, dates, and more. Configure column
      properties, validation rules, and organize your data schema.
  - name: Formula Management
    description: >-
      🧮 **Create calculated fields** - Build dynamic Formula columns that
      automatically calculate values based on other columns in your table.
      Perfect for CRM calculations like deal values, commissions, and lead
      scoring.
  - name: Data Operations
    description: >-
      📝 **Work with your data** - The core endpoints for managing your actual
      data. Insert new records, update existing ones, delete data, and retrieve
      information with powerful filtering and search capabilities.
  - name: Advanced Queries
    description: >-
      🔍 **Powerful data analysis** - Advanced querying capabilities including
      complex filtering, aggregations, grouping, and custom search operations.
      Perfect for analytics and reporting.
  - name: Transaction History
    description: >-
      📋 **Audit and monitoring** - Track all changes and operations performed
      on your databases. View transaction logs, get statistics, and maintain a
      complete audit trail of your data operations.
  - name: Account
    description: Account
  - name: Agents
    description: Agents
  - name: Agents - Skills
    description: Agents - Skills
  - name: Agents - Tools
    description: Agents - Tools
  - name: Agents - Runs
    description: Agents - Runs
  - name: Row Comments
    description: Row Comments
  - name: Bulk Data Operations
    description: Bulk Data Operations
  - name: Browser Utilities
    description: Browser Utilities
  - name: Utility Management
    description: Utility Management
  - name: File Utilities
    description: File Utilities
  - name: Image Utilities
    description: Image Utilities
  - name: Media Utilities
    description: Media Utilities
  - name: Vector Collections
    description: Vector Collections
  - name: Vector Store
    description: Vector Store
  - name: Vector Points
    description: Vector Points
  - name: Vector Search
    description: Vector Search
paths:
  /transactions:
    get:
      tags:
        - Transaction History
      summary: List database transactions
      description: Returns paginated list of database transactions with filtering options.
      operationId: getDatabaseTransactions
      parameters:
        - name: database_id
          in: query
          description: Filter by database ID
          schema:
            type: string
            format: uuid
        - name: per_page
          in: query
          description: Number of transactions per page
          schema:
            type: integer
            default: 25
            maximum: 100
            minimum: 1
        - name: transaction_type
          in: query
          description: Filter by transaction type
          schema:
            type: string
            enum:
              - ddl
              - dml
              - admin
        - name: success
          in: query
          description: Filter by success status
          schema:
            type: boolean
      responses:
        '200':
          description: Transactions retrieved successfully
          content:
            application/json:
              schema:
                properties:
                  data:
                    type: array
                    items:
                      properties:
                        id:
                          type: string
                          format: uuid
                        transaction_type:
                          type: string
                        operation_type:
                          type: string
                        success:
                          type: boolean
                        execution_time_ms:
                          type: integer
                        created_at:
                          type: string
                          format: date-time
                      type: object
                  current_page:
                    type: integer
                  per_page:
                    type: integer
                  total:
                    type: integer
                type: object
      security:
        - sanctum: []
components:
  securitySchemes:
    sanctum:
      type: apiKey
      description: Enter token in format (Bearer <token>)
      name: Authorization
      in: header

````