# Aurora

## Docs

- [Get authenticated user's session data](https://docs.moonly.ai/api-reference/account/get-authenticated-users-session-data.md): Returns comprehensive session information including user profile, current organisation, roles, and permissions.
- [Advanced query with filtering](https://docs.moonly.ai/api-reference/advanced-queries/advanced-query-with-filtering.md): Executes advanced queries with complex filtering, grouping, sorting, and aggregation capabilities.
- [Aggregate table data](https://docs.moonly.ai/api-reference/advanced-queries/aggregate-table-data.md): Performs aggregation operations on table data without grouping.
- [Get distinct values](https://docs.moonly.ai/api-reference/advanced-queries/get-distinct-values.md): Returns distinct values for a specified column, with optional filtering.
- [Cancel a running agent](https://docs.moonly.ai/api-reference/agents--runs/cancel-a-running-agent.md): Attempt to cancel an agent that is currently running.
- [Get a specific run](https://docs.moonly.ai/api-reference/agents--runs/get-a-specific-run.md): Retrieve detailed information about a specific agent run.
- [Get run statistics](https://docs.moonly.ai/api-reference/agents--runs/get-run-statistics.md): Get aggregated statistics for agent runs.
- [List runs for an agent](https://docs.moonly.ai/api-reference/agents--runs/list-runs-for-an-agent.md): Get the run history for a specific agent. Useful for monitoring agent performance and debugging issues.
- [Attach skill to agent](https://docs.moonly.ai/api-reference/agents--skills/attach-skill-to-agent.md): Attach a skill to an agent with optional configuration.
- [Detach skill from agent](https://docs.moonly.ai/api-reference/agents--skills/detach-skill-from-agent.md): Remove a skill from an agent.
- [List agent's skills](https://docs.moonly.ai/api-reference/agents--skills/list-agents-skills.md): Get all skills attached to a specific agent.
- [Update agent skill configuration](https://docs.moonly.ai/api-reference/agents--skills/update-agent-skill-configuration.md): Update the configuration for a skill attached to an agent.
- [Attach tool to agent](https://docs.moonly.ai/api-reference/agents--tools/attach-tool-to-agent.md): Add a tool to an agent with optional configuration.
- [Detach tool from agent](https://docs.moonly.ai/api-reference/agents--tools/detach-tool-from-agent.md): Remove a tool from an agent.
- [List agent's tools](https://docs.moonly.ai/api-reference/agents--tools/list-agents-tools.md): Get all tools attached to a specific agent.
- [Update agent tool configuration](https://docs.moonly.ai/api-reference/agents--tools/update-agent-tool-configuration.md): Update the configuration for a tool attached to an agent.
- [Create an agent](https://docs.moonly.ai/api-reference/agents/create-an-agent.md): Create a new AI agent with custom instructions and personality.
- [Delete an agent](https://docs.moonly.ai/api-reference/agents/delete-an-agent.md): Permanently remove an agent. Cannot delete global agents.
- [Get an agent](https://docs.moonly.ai/api-reference/agents/get-an-agent.md): Retrieve detailed information about a specific agent.
- [List all agents](https://docs.moonly.ai/api-reference/agents/list-all-agents.md): Get a list of all agents available to your organisation. This includes global agents (like Aria) and organisation-specific agents you've created.
- [Run an agent](https://docs.moonly.ai/api-reference/agents/run-an-agent.md): Execute the agent with a message and get a response. This creates a new run record and returns the agent's response.
- [Update an agent](https://docs.moonly.ai/api-reference/agents/update-an-agent.md): Update agent settings. You can only update agents belonging to your organisation, not global agents.
- [Capture screenshot of a web page](https://docs.moonly.ai/api-reference/browser-utilities/capture-screenshot-of-a-web-page.md): Generate screenshots of any publicly accessible web page with customizable viewport size and options.
- [Generate PDF from URL](https://docs.moonly.ai/api-reference/browser-utilities/generate-pdf-from-url.md): Convert web pages to PDF documents with custom formatting options.
- [Bulk insert rows](https://docs.moonly.ai/api-reference/bulk-data-operations/bulk-insert-rows.md): Inserts multiple rows efficiently with validation and logging.
- [Add column choices](https://docs.moonly.ai/api-reference/column-management/add-column-choices.md): Adds new choices to a select-type column.
- [Create a new column](https://docs.moonly.ai/api-reference/column-management/create-a-new-column.md): Creates a new column in both the model and the actual database table.
- [Delete a column](https://docs.moonly.ai/api-reference/column-management/delete-a-column.md): Permanently remove a column and all its data from your table.
- [Delete column choices](https://docs.moonly.ai/api-reference/column-management/delete-column-choices.md): Removes choices from a select-type column.
- [Get available column types](https://docs.moonly.ai/api-reference/column-management/get-available-column-types.md): Returns all available column types with their descriptions and options.
- [Get column details](https://docs.moonly.ai/api-reference/column-management/get-column-details.md): Returns detailed information about a specific column.
- [Get column types available for a table](https://docs.moonly.ai/api-reference/column-management/get-column-types-available-for-a-table.md): Returns column types that can be used for a specific table.
- [Get specific column type details](https://docs.moonly.ai/api-reference/column-management/get-specific-column-type-details.md): Returns detailed information about a specific column type.
- [List column choices](https://docs.moonly.ai/api-reference/column-management/list-column-choices.md): Returns available choices for a select-type column.
- [List columns for a table](https://docs.moonly.ai/api-reference/column-management/list-columns-for-a-table.md): Returns all active columns for a specific database table.
- [Update a column](https://docs.moonly.ai/api-reference/column-management/update-a-column.md): Modify column properties like name, description, or options.
- [Update column color](https://docs.moonly.ai/api-reference/column-management/update-column-color.md): Updates the display color for a column.
- [Update column formatting](https://docs.moonly.ai/api-reference/column-management/update-column-formatting.md): Updates display formatting options for a column.
- [Update column order](https://docs.moonly.ai/api-reference/column-management/update-column-order.md): Updates the display order of columns in a table.
- [Create table rows](https://docs.moonly.ai/api-reference/data-operations/create-table-rows.md): Creates one or more rows in a table. Supports both single row and bulk insert operations.
- [Delete table rows](https://docs.moonly.ai/api-reference/data-operations/delete-table-rows.md): Deletes one or more rows from a table by their IDs.
- [Get a specific row](https://docs.moonly.ai/api-reference/data-operations/get-a-specific-row.md): Returns a single row by its ID from a specific table.
- [List table rows](https://docs.moonly.ai/api-reference/data-operations/list-table-rows.md): Returns paginated rows from a database table with filtering, sorting, and optional metadata.
- [Update table rows](https://docs.moonly.ai/api-reference/data-operations/update-table-rows.md): Updates one or more rows in a table. Supports both single row and bulk update operations.
- [Create a new database](https://docs.moonly.ai/api-reference/database-management/create-a-new-database.md): **Two options:** Create a brand new managed PostgreSQL database (we handle everything!) or connect to your existing database. For managed databases, we'll spin up a new PostgreSQL instance for you. For external databases, just provide your connection details.
- [Delete a database](https://docs.moonly.ai/api-reference/database-management/delete-a-database.md): Permanently deletes a database. For managed PostgreSQL databases, also removes the database from Digital Ocean.
- [Get a specific database](https://docs.moonly.ai/api-reference/database-management/get-a-specific-database.md): Returns detailed information about a specific database including tables count and metadata.
- [List all databases](https://docs.moonly.ai/api-reference/database-management/list-all-databases.md): **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.
- [Test database connection](https://docs.moonly.ai/api-reference/database-management/test-database-connection.md): Tests the connection to a specific database and returns the connection status.
- [Update a database](https://docs.moonly.ai/api-reference/database-management/update-a-database.md): Updates database configuration including connection settings and metadata.
- [Compress a file](https://docs.moonly.ai/api-reference/file-utilities/compress-a-file.md): Compress files to reduce size while maintaining quality.
- [Convert file to another format](https://docs.moonly.ai/api-reference/file-utilities/convert-file-to-another-format.md): Convert files between different formats with configurable quality and compression settings.
- [Get available formula functions](https://docs.moonly.ai/api-reference/formula-management/get-available-formula-functions.md): Returns all available functions and operators for use in formulas.
- [Update formula expression](https://docs.moonly.ai/api-reference/formula-management/update-formula-expression.md): Updates a formula column's expression by dropping and recreating the generated column.
- [Validate formula expression](https://docs.moonly.ai/api-reference/formula-management/validate-formula-expression.md): Validates a formula expression and returns parsing information.
- [Compress image with quality control](https://docs.moonly.ai/api-reference/image-utilities/compress-image-with-quality-control.md): Reduce image file size while maintaining visual quality. Perfect for optimizing images for web delivery.
- [Convert image to different format](https://docs.moonly.ai/api-reference/image-utilities/convert-image-to-different-format.md): Convert images between formats while optionally resizing and optimizing.
- [Crop image to specific dimensions](https://docs.moonly.ai/api-reference/image-utilities/crop-image-to-specific-dimensions.md): Crop images to exact dimensions with position control.
- [Get image information without processing](https://docs.moonly.ai/api-reference/image-utilities/get-image-information-without-processing.md): Extract metadata from an image file.
- [Optimize image for web delivery](https://docs.moonly.ai/api-reference/image-utilities/optimize-image-for-web-delivery.md): Apply automatic optimizations for best web performance. Combines compression, format conversion, and optimization techniques.
- [Process images with multiple operations](https://docs.moonly.ai/api-reference/image-utilities/process-images-with-multiple-operations.md): Apply one or more transformations to images. Supports both file uploads and URL-based processing.
- [Resize image to specific dimensions](https://docs.moonly.ai/api-reference/image-utilities/resize-image-to-specific-dimensions.md): Quick endpoint for simple image resizing without complex operations.
- [Optimize an image](https://docs.moonly.ai/api-reference/media-utilities/optimize-an-image.md): Optimize images for web delivery with smart compression and quality settings.
- [Resize an image](https://docs.moonly.ai/api-reference/media-utilities/resize-an-image.md): Resize images to specific dimensions while maintaining aspect ratio or cropping to exact dimensions.
- [Create a comment](https://docs.moonly.ai/api-reference/row-comments/create-a-comment.md): Creates a new comment on a database table row.
- [List comments for a row](https://docs.moonly.ai/api-reference/row-comments/list-comments-for-a-row.md): Returns all comments for a specific database table row with pagination.
- [Create a new table](https://docs.moonly.ai/api-reference/table-operations/create-a-new-table.md): Creates a new table in both the model and the actual database. Auto-creates id, created_at, and updated_at columns.
- [Delete a table](https://docs.moonly.ai/api-reference/table-operations/delete-a-table.md): Permanently deletes a table and all its data from both the model and the actual database.
- [Get table details](https://docs.moonly.ai/api-reference/table-operations/get-table-details.md): Returns detailed information about a specific table including its columns.
- [List tables for a database](https://docs.moonly.ai/api-reference/table-operations/list-tables-for-a-database.md): Returns all active tables for a specific database.
- [Truncate a table](https://docs.moonly.ai/api-reference/table-operations/truncate-a-table.md): Removes all data from a table while preserving its structure. Faster than deleting all rows and resets auto-increment counters.
- [Update a table](https://docs.moonly.ai/api-reference/table-operations/update-a-table.md): Updates table metadata including name and description.
- [Get specific transaction](https://docs.moonly.ai/api-reference/transaction-history/get-specific-transaction.md): Returns detailed information about a specific database transaction.
- [Get transaction statistics](https://docs.moonly.ai/api-reference/transaction-history/get-transaction-statistics.md): Returns statistical information about database transactions.
- [List database transactions](https://docs.moonly.ai/api-reference/transaction-history/list-database-transactions.md): Returns paginated list of database transactions with filtering options.
- [Check utility services health](https://docs.moonly.ai/api-reference/utility-management/check-utility-services-health.md): Returns health status and performance metrics for all utility services.
- [Get specific utility activity details](https://docs.moonly.ai/api-reference/utility-management/get-specific-utility-activity-details.md): Retrieve complete details about a specific utility operation including full request/response data and error information.
- [Get utility usage statistics](https://docs.moonly.ai/api-reference/utility-management/get-utility-usage-statistics.md): Returns comprehensive statistical information about utility usage including performance, costs, and success rates.
- [List available utilities](https://docs.moonly.ai/api-reference/utility-management/list-available-utilities.md): Returns a comprehensive list of all available utility services with their capabilities and limitations.
- [List recent utility activities](https://docs.moonly.ai/api-reference/utility-management/list-recent-utility-activities.md): Get a paginated list of recent utility operations with filtering options.
- [Create a new collection](https://docs.moonly.ai/api-reference/vector-collections/create-a-new-collection.md): Create a new vector collection with specified configuration.
- [Delete collection](https://docs.moonly.ai/api-reference/vector-collections/delete-collection.md): Permanently delete a vector collection and all its points.
- [Get collection details](https://docs.moonly.ai/api-reference/vector-collections/get-collection-details.md): Retrieve detailed information about a specific vector collection.
- [List accessible collections](https://docs.moonly.ai/api-reference/vector-collections/list-accessible-collections.md): Get a paginated list of vector collections accessible to the current user.
- [Optimize collection](https://docs.moonly.ai/api-reference/vector-collections/optimize-collection.md): Trigger collection optimization in Qdrant.
- [Sync stats from Qdrant](https://docs.moonly.ai/api-reference/vector-collections/sync-stats-from-qdrant.md): Synchronize collection statistics from Qdrant.
- [Update collection metadata](https://docs.moonly.ai/api-reference/vector-collections/update-collection-metadata.md): Update collection name, description, and metadata.
- [Clear all payload from points](https://docs.moonly.ai/api-reference/vector-points/clear-all-payload-from-points.md): Clear all payload data from specified points.
- [Count points in collection](https://docs.moonly.ai/api-reference/vector-points/count-points-in-collection.md): Count points in a collection, optionally filtered.
- [Delete payload keys](https://docs.moonly.ai/api-reference/vector-points/delete-payload-keys.md): Delete specific payload keys from points.
- [Delete points from collection](https://docs.moonly.ai/api-reference/vector-points/delete-points-from-collection.md): Delete points by IDs or filter criteria.
- [Get single point by ID](https://docs.moonly.ai/api-reference/vector-points/get-single-point-by-id.md): Retrieve a specific point by its ID.
- [Overwrite entire payload](https://docs.moonly.ai/api-reference/vector-points/overwrite-entire-payload.md): Overwrite the entire payload for points.
- [Scroll through points](https://docs.moonly.ai/api-reference/vector-points/scroll-through-points.md): Scroll through points in a collection with filtering and pagination.
- [Set payload fields](https://docs.moonly.ai/api-reference/vector-points/set-payload-fields.md): Set or update payload fields for points.
- [Upsert points into collection](https://docs.moonly.ai/api-reference/vector-points/upsert-points-into-collection.md): Insert or update points (vectors with payload) in a collection.
- [Batch recommendations](https://docs.moonly.ai/api-reference/vector-search/batch-recommendations.md): Perform multiple recommendation searches in a single request.
- [Batch search](https://docs.moonly.ai/api-reference/vector-search/batch-search.md): Perform multiple searches in a single request.
- [Discovery search](https://docs.moonly.ai/api-reference/vector-search/discovery-search.md): Discover points similar to target but different from context.
- [Facet aggregation](https://docs.moonly.ai/api-reference/vector-search/facet-aggregation.md): Get facet aggregations for a payload key.
- [Grouped search](https://docs.moonly.ai/api-reference/vector-search/grouped-search.md): Perform search with result grouping.
- [Recommendation search](https://docs.moonly.ai/api-reference/vector-search/recommendation-search.md): Find recommendations based on positive and negative examples.
- [Universal query](https://docs.moonly.ai/api-reference/vector-search/universal-query.md): Perform a universal query combining vector and filter search.
- [Vector similarity search](https://docs.moonly.ai/api-reference/vector-search/vector-similarity-search.md): Perform similarity search using a query vector.
- [Check vector store health](https://docs.moonly.ai/api-reference/vector-store/check-vector-store-health.md): Check the health and readiness status of the Qdrant vector database service.
- [Get cluster information](https://docs.moonly.ai/api-reference/vector-store/get-cluster-information.md): Retrieve cluster information for distributed Qdrant deployments.
- [Get Qdrant service info](https://docs.moonly.ai/api-reference/vector-store/get-qdrant-service-info.md): Retrieve information about the Qdrant vector database service including version, capabilities, and configuration details.
- [Get vector store metrics](https://docs.moonly.ai/api-reference/vector-store/get-vector-store-metrics.md): Retrieve telemetry and performance metrics from the Qdrant service.
- [Welcome to Aurora](https://docs.moonly.ai/introduction.md): The intelligent data engine for modern workflows

## OpenAPI Specs

- [openapi](https://docs.moonly.ai/openapi.json)