Answers from your database
Write one parameterized query. The model never sees it: it sees the parameters, and fills them in from the question. Smarter runs the query over a Connection to MySQL, PostgreSQL, SQL Server, Oracle and others, and hands back the rows.
Ask it“My budget is $1,000. Which AI courses can I take?”
- Every value is inserted as a quoted, escaped literal, so a question can never become SQL.
- An enum limits a parameter to the values your data actually holds.
- The database password is a Secret, never part of the manifest.
- A row limit, and test values to try the query before any model calls it.
connection: stackademy_catalog_dbsqlData:sqlQuery: SELECT c.course_code, c.course_name, c.costFROM courses cWHERE (c.description LIKE CONCAT('%', {description}, '%')OR {description} IS NULL)AND (c.cost <= {max_cost} OR {max_cost} IS NULL)parameters:- name: max_costtype: numberdescription: the maximum cost that a student is willing to pay.- name: descriptiontype: stringenum: [AI, mobile, web, database, network]limit: 10