> ## 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 all databases > **Start here!** Get a list of all your databases. This shows you everything you have access to, including managed PostgreSQL databases and external connections. Perfect for building dashboards or getting an overview of your data infrastructure. ## OpenAPI ````yaml openapi.json get / 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: /: get: tags: - Database Management summary: List all databases description: >- **Start here!** Get a list of all your databases. This shows you everything you have access to, including managed PostgreSQL databases and external connections. Perfect for building dashboards or getting an overview of your data infrastructure. operationId: getDatabases responses: '200': description: List of databases retrieved successfully content: application/json: schema: properties: databases: type: array items: properties: id: type: string format: uuid example: 550e8400-e29b-41d4-a716-446655440000 name: type: string example: My Database description: type: string example: Database description nullable: true icon_url: type: string example: database-icon.svg nullable: true icon_color: type: string example: '#60a5fa' nullable: true connection_type: type: string enum: - managed_pg - external_db example: managed_pg connection_db_name: type: string example: aurora_db_123 nullable: true status: type: string example: active is_public: type: boolean example: false created_at: type: string format: date-time connection_summary: properties: type: type: string host: type: string database: type: string can_connect: type: boolean type: object organisation: properties: id: type: string format: uuid name: type: string type: object nullable: true tables: type: array items: properties: id: type: string format: uuid name: type: string ref_table_name: type: string total_records: type: integer formatted_total_records: type: string type: object type: object type: object '401': description: Unauthorized - Invalid or missing authentication token content: application/json: schema: properties: message: type: string example: Unauthenticated. type: object '500': description: Internal server error content: application/json: schema: properties: error: type: boolean example: true message: type: string trace_id: type: string format: uuid timestamp: type: string format: date-time type: object security: - sanctum: [] components: securitySchemes: sanctum: type: apiKey description: Enter token in format (Bearer ) name: Authorization in: header ````