can't run any llm command for my local db. error: Preparing schema information to feed the llm near "1": syntax error

Open
#253 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
45/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Quiet
Tech stack
python, sqlite
Domain
cli, database

Research direction

Reproduce the failure with the reported local SQLite database using the \llm "top 5 products" command, then compare it with the working \llm chat entry point. Trace the schema-preparation path that runs before text prompts and identify why it produces a syntax error near 1. Done means text prompts work for the local database without the error and chat still works.

Written by the indexing model from the issue text.

Description

plugin llm set, api set, local one as well had been tried.
the \llm chat itself works but \llm "text" does not.

any solutions?

❯ litecli Desktop/courses/stuff-and-data/sTunes.db
LiteCli: 1.17.1 (SQLite: 3.53.0)
GitHub: https://github.com/dbcli/litecli

Desktop/courses/stuff-and-data/sTunes.db> \llm "top 5 products"

Preparing schema information to feed the llm
near "1": syntax error
Dominant language
Python
Stars
3.3k
Forks
95
PR merge metrics
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from dbcli/litecli

All issues in dbcli/litecli

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.