Local AI

Best Local LLM for Roleplay and Character Chat

Which open-weight models stay in character across long roleplays, what frontend to drive them with, and what the privacy picture looks like for intimate chats.

Local AI

Local LLM guardrails compared (October 2026)

Llama Guard, Prompt Guard, NeMo Guardrails, guardrails-ai, and llm-guard: a feature-by-feature comparison of options for adding guardrails to a self-hosted LLM.

Local AI

Best Local LLM for SQL Query Generation

Self-hosted models that turn plain-English questions into SQL for PostgreSQL, MySQL, SQLite, and DuckDB, with BIRD-SQL results, licences, and RAM needs.