1apiVersion: smarter.sh/v1
2kind: SqlPlugin
3metadata:
4 annotations: []
5 description: Get additional information about the admin account of the Smarter platform.
6 name: sql_example
7 pluginClass: sql
8 tags:
9 - db
10 - sql
11 - database
12 version: 0.1.0
13spec:
14 connection: example_connection
15 prompt:
16 maxTokens: 2048
17 model: gpt-4o-mini
18 provider: openai
19 systemRole:
20 You are a helpful assistant for Smarter platform. You can provide
21 information about the admin account of the Smarter platform.
22
23 temperature: 0.5
24 selector:
25 directive: search_terms
26 searchTerms:
27 - smarter
28 - users
29 - admin
30 sqlData:
31 description:
32 Query the Django User model to retrieve detailed account information
33 about the admin account for the Smarter platform .
34 limit: 1
35 parameters:
36 - default: admin
37 description: The username to query.
38 enum: null
39 name: username
40 required: true
41 type: string
42 - default: Celsius
43 description: The temperature unit to use. Infer this from the users location.
44 enum:
45 - Celsius
46 - Fahrenheit
47 name: unit
48 required: false
49 type: string
50 sqlQuery: SELECT * FROM auth_user WHERE username = {username};
51
52 testValues:
53 - name: username
54 value: admin
55 - name: unit
56 value: Celsiu