The AI chat can query your application data or create and update records on your behalf. You ask in natural language and the Codenull Agent translates your intent into the same per-table GraphQL queries and mutations your application uses, so every answer respects what your role is allowed to see and edit.
Queries and transactions used to be served by two dedicated agents. They were removed: the Codenull Agent now handles both, in every chat mode. The video below was recorded with the previous agents; the questions you can ask are the same.
Requirements
Two things must be true for the chat to read or write business data:
- Your role has the agent permission. AI Search (
agent-search) to query data, AI Transactions (agent-transactions) to create or update records.
- The application enforces per-entity permissions. Without enforcement the platform has no way to limit the chat to the tables and records your role may access, so the data tools are not offered to non-administrator users.
How these two combine, and what each permission unlocks, is explained with a diagram in Agent Permissions.
If enforcement is not enabled for the application, the chat does not query or modify data for non-administrator users. It tells you so, instead of answering: an administrator has to enable per-entity permission enforcement for the application before queries and transactions work from the chat. Administrators are not affected.
Querying data
Ask the agent to retrieve data from your application. For example:
- “Show me the last 10 orders placed today”
- “How many users registered this month?”
- “List the pending invoices for client Acme”
The agent reads through the table’s own queries (including the aggregate query for counts, sums and groupings) and answers in the chat, with a chart when the data reads better visually. It knows who is asking, so “my orders” or “assigned to me” resolve to your user.
Creating and updating records
With the transactions permission the agent can also write:
- “Create a new customer with name John Doe and email john@example.com”
- “Update the status of order #1234 to Delivered”
Every write shows a confirmation card with the exact operation, and nothing is executed until you approve it. A card expires after 10 minutes; ask again if it did.
Records cannot be deleted from the chat. Delete them from the application screens instead.