Databases
Find answers about Databases, from setup to everyday use.
What is a managed database here?
NoSQL is a MongoDB database of your own; SQL is your own file, queried with ordinary SQL. Both are created in a click, and both are reachable from the agent, the workflows and the SDK with no connection string to carry around.
Does the agent need to be told my schema?
No. Collections with their counts and tables with their columns are put in front of it at the start of every answer. It reads the shape of your data before it writes anything.
Can it delete my data?
Only with your approval, and only after the guards. A write is asked even in Auto mode, an empty filter or a missing WHERE is refused at the tool before the prompt is even shown, and a DROP exists only in Full access.
What if I outgrow the included space?
Buy gigabytes at 100 credits per GB per month. They form a pool shared by NoSQL and SQL, so an overrun on either draws from the same purchase.
How should I prepare a database for questions from an agent?
Use clear names and consistent fields, then explain the business meaning of data the schema cannot describe.
What should I consider before changing a database schema?
Identify queries and workflows that use the affected fields, then update and verify them against the new structure.
Why did my database query return no results?
Check the selected database and collection or table, then verify field names, filter values, and any date or status conditions.
Can I connect a database I already use?
Yes. Add the connection details through the storage connection flow, then run a small read query to confirm the target and access.
Why does my database query return no records?
Check the selected database, collection or table, filters, and environment before concluding that the data is missing.
How can I test a database change before using it in production?
Try the change against a separate development dataset first, inspect the result, and confirm that the production connection is not selected.
Should a read-only database task use credentials that can write data?
No. Give a task that only needs to read data a connection with read access only, and reserve write permissions for operations that truly require them.
Why can a database connection succeed while the first query fails?
Creating a connection object may only save the connection settings. The first query is where the application actually tries the URI, credentials, database name, and permissions.