delete_row
Delete Row
Delete one or more rows from a database table by primary key. Supports both single and bulk deletion.
delete_row
Delete one or more rows from a database table by primary key. Supports both single and bulk deletion.
manage_action_rules
List, create, update, or delete action rules for a table. Action rules define triggers and webhook-based actions that fire when table events occur (e.g., row created, updated, or deleted).
update_row
Update an existing row in a database table by its primary key. Supports updating a single row or multiple rows in bulk.
get_audit_logs
Retrieve activity logs for a database connection. Supports filtering by table name, user, and date range. Also supports fetching sign-in audit logs.
manage_groups
List, create, or delete groups within a database connection. Groups control user access at the table and field level. Also supports adding and removing users from groups.
manage_company_users
Manage users within a Rocketadmin company (organization). Invite new users, list existing members, remove users, or suspend/unsuspend accounts.
add_row
Insert a new row into a database table. Provide column values as key-value pairs matching the table's schema.
list_tables
List all tables in a database connection and optionally get the structure (columns, types, constraints) of a specific table.
get_rows
Retrieve rows from a database table. Supports pagination, sorting, search, and filtering. Use filters to query specific data subsets. Can also fetch a single row by primary key.
manage_connection
Create, update, test, or delete a database connection. Supports PostgreSQL, MySQL, MongoDB, MSSQL, Oracle, MariaDB, IBM Db2, ScyllaDB, and others. Use this to configure how Rocketadmin connects to your databases.
export_csv
Export all data from a database table as CSV format. Returns the CSV content as a string.
manage_dashboards
List, create, update, or delete dashboards for a database connection. Dashboards provide data visualization through customizable widgets.
manage_table_settings
Get, create, update, or delete display settings for a table. Table settings control how data is displayed including column ordering, visibility, search fields, and more.
manage_saved_queries
Create, list, execute, update, or delete saved database queries. Saved queries let you store and reuse frequently needed SQL statements.
list_connections
Retrieve all database connections configured in your Rocketadmin account. Returns connection details including database type, host, port, and configuration status.
Connect to and manage databases (PostgreSQL, MySQL, MongoDB, MSSQL, Oracle, MariaDB, and others) through an auto-generated admin panel. Perform full CRUD operations on table rows including add, read, update, delete, and bulk operations. Export and import table data as CSV files. Manage database connections, configure table settings, and create saved queries. Set up granular user permissions with groups, roles, and field-level access control. Create dashboards with data visualization widgets. Define action rules and custom webhook-based actions triggered by row events. Query data using natural language AI. Manage companies, users, and secrets. Export audit logs filtered by date, user, and table.
Common questions about connecting Rocketadmin to AI agents with Metorial.