dbcli / dbcli/litecli

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
Dominant language
Python
Stars
3.3k
Forks
95
PR merge metrics
No merged PRs in 30d

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
```

Contributor guide

Open the contributing guide

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.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.