save_knowledge
Persist discovered knowledge about an SQL Server database schema, table structures, query patterns, and data meanings for use in future conversations.
Instructions
Save learned information about the SQL Server database.
Use this to persist useful discoveries about the database schema,
table structures, query patterns, and data meanings. This information
will be available in future conversations.
Good things to save:
- Table purposes (e.g., "Customers contains customer master records")
- Column meanings (e.g., "In Orders, StatusCode 1=Pending, 2=Shipped")
- Working query patterns that produced good results
- Relationships between tables (foreign keys, joins)
- Data format notes (date formats, codes, etc.)
- Stored procedure documentation
Args:
topic: A short descriptive name for this knowledge
(e.g., "Customers table", "Order queries", "Status codes")
content: The knowledge to save. Use markdown formatting.
append: If True, add to existing topic. If False, replace it.
Returns:
Status of the save operation.
Examples:
save_knowledge("dbo.Customers", "Customer master table. PK is CustomerID.")
save_knowledge("Date formats", "Dates stored as datetime2. Use FORMAT() for display.")
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| topic | Yes | ||
| append | No | ||
| content | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||