Snippet Example

VSCode Style Snippets

codebase_panel.json

{
  "all_file": {
    "prefix": "all_file",
    "body": [
      "SELECT *",
      "FROM code_chunks;"
    ],
    "description": "Select all from code_chunks"
  },
  "basic": {
    "prefix": "basic",
    "body": [
      "SELECT file_path, embedding <=> %(embedding)s::vector as distance",
      "FROM code_chunks",
      "-- always use double %%",
      "-- WHERE file_path LIKE '%%.py'",
      "-- a placeholder for the embedding vector, <=> means cosine similarity",
      "ORDER BY embedding <=> %(embedding)s::vector",
      "LIMIT 10;"
    ],
    "description": "Basic ANN Search"
  }
}