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

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.