SQL Plugin Example Manifest

 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-6-luna
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: 1.0
24  selector:
25    directive: search_terms
26    searchTerms:
27      - smarter
28      - users
29      - admin
30  sqlData:
31    limit: 1
32    parameters:
33      - default: admin
34        description: The username to query.
35        enum: null
36        name: username
37        required: true
38        type: string
39      - default: Celsius
40        description: The temperature unit to use. Infer this from the users location.
41        enum:
42          - Celsius
43          - Fahrenheit
44        name: unit
45        required: false
46        type: string
47    sqlQuery: SELECT * FROM auth_user WHERE username = {username};
48
49    testValues:
50      - name: username
51        value: admin
52      - name: unit
53        value: Celsiu