cassandra-cql

tools:
  search_users_by_email:
    kind: cassandra-cql
    source: my-cassandra-cluster
    statement: |
      SELECT user_id, email, first_name, last_name, created_at 
      FROM users 
      WHERE email = ?
    description: |
      Use this tool to retrieve specific user information by their email address.
      Takes an email address and returns user details including user ID, email, 
      first name, last name, and account creation timestamp.
      Do NOT use this tool with a user ID or other identifiers.
      Example:
      {{
          "email": "user@example.com",
      }}
    parameters:
      - name: email
        type: string
        description: User's email address

tools:
  list_keyspace_table:
    kind: cassandra-cql
    source: my-cassandra-cluster
    statement: |
      SELECT * FROM {{.keyspace}}.{{.tableName}};
    description: |
      Use this tool to list all information from a specific table in a keyspace.
      Example:
      {{
          "keyspace": "my_keyspace",
          "tableName": "users",
      }}
    templateParameters:
      - name: keyspace
        type: string
        description: Keyspace containing the table
      - name: tableName
        type: string
        description: Table to select from