Summarize Table Records
Read [base and table] and summarize records matching [conditions]. Explain the fields used in your summary.
nocodb
NocoDB AI Employee
Leina connects to NocoDB to help you review table records, update rows, and merge imported data. Ask in your team chat. Leina does the work and brings back the result.
Connect NocoDB, choose what to share, and hand off your first task.
Leina + NocoDB Example Result
You
In [base and table], set the selected Launch brief and Demo recording records to Ready for review. Keep all other values.
Leina
I updated the status on both selected records.
NocoDB · Records updated
Ready for review
Two launch tasks have the new status.
- Launch brief
- Status: Ready for review
- Demo recording
- Status: Ready for review
What Is a NocoDB AI Agent?
A NocoDB AI agent reads table records, applies specified edits, and merges supplied rows using the matching fields you choose.
You specify the source and the destination. Leina uses the content available to your connection and returns the result for you to review.
NocoDB
NocoDB provides a spreadsheet-style interface for structured data and shared tables.
-
Select the records
Identify the table and rows to edit.
-
Specify the values
Name the fields and changes you want.
-
Save the updates
Apply only the requested changes.
What to Ask Leina to Do with NocoDB
Copy a prompt, add your details, and send it to Leina in your connected team chat.
Update Selected Records
In [base and table], update the selected records with [changes]. Keep other fields unchanged.
nocodb
Merge Imported Records
Merge these records into [base and table], matching on [up to three fields]. Update matching rows and create rows for new entries.
nocodb
Your next NocoDB task can start with a message.
Connect. Ask. Get the Result.
Tell Leina what you need in your team chat. Include the source, destination, and expected result.
-
Connect Your Account
Connect the tools involved and give Leina access to the content it needs.
-
Try a Task
Share the source material, say where the result belongs, and describe what you need.
-
Check the Result
Review the result and any changes in the connected app.
Put Leina to Work in NocoDB
Hand off these everyday tasks to your AI employee.
Get Current User
Get the NocoDB user associated with the connected API token.
List Bases
List bases visible to the connected NocoDB API token.
Get Base Schema
Get schema metadata for one NocoDB base.
List Tables
List tables in a NocoDB base or in a specific base source.
Create Table
Create a table in a NocoDB base using the v3 metadata API.
Get Table Metadata
Get metadata for one NocoDB table, including columns and views when available.
Update Table
Update a NocoDB table title, description, display field, or metadata using the v3 metadata API.
Delete Table
Delete a NocoDB table using the v3 metadata API.
List Table Views
List views for a NocoDB table using the v3 metadata API.
Create Table View
Create a view for a NocoDB table using the v3 metadata API.
Create Table Field
Create a field in a NocoDB table using the v3 metadata API.
List Records
List records from one NocoDB table with optional where, sort, field, limit, and offset query parameters.
Count Records
Count records in one NocoDB table, optionally filtered by a where expression.
Read Record
Read one record from a NocoDB table by record ID.
Create Records
Create one or more records in a NocoDB table.
Update Records
Update one or more records in a NocoDB table.
Delete Records
Delete one or more records from a NocoDB table.
List Table Records
List records from one NocoDB table using the v3 data API with optional field, sort, filter, page, and view parameters.
Count Table Records
Count records in one NocoDB table using the v3 data API.
Read Table Record
Read one record from a NocoDB table using the v3 data API.
Create Table Records
Create one or more records in a NocoDB table using the v3 data API.
Update Table Records
Update one or more records in a NocoDB table using the v3 data API.
Delete Table Records
Delete one or more records from a NocoDB table using the v3 data API.
Upsert Table Records
Create or update records in a NocoDB table by matching up to three fields using the v3 data API.
More Tools for Your AI Employee
Connect the Apps your work depends on, and give Leina the context to carry the task forward.
Keep the Conversation Moving. Let Leina Pick Up the Work.
Hand off a task while your team is discussing it. Leina uses your connected tools and brings the result back to the conversation.
See How Leina Works in SlackLeinaExample Result I updated the status on both selected records.
Ready for review
NocoDB + Leina: Your Questions, Answered
Can I avoid duplicate rows when importing?
Yes. Choose up to three fields that identify matching records so existing rows can be updated.
Can the assistant learn the table’s fields?
Yes. It can read the table’s structure before filtering or organizing records.
Will a summary include the whole table?
Large tables are read in batches. Specify the scope and ask the assistant to state how much it reviewed.
Make Leina Your NocoDB AI Employee
Start with one task you already need to do. Tell Leina what a finished result should look like.
Connect NocoDB, choose what to share, and hand off your first task.