--- title: Valentina Release 18.2.1 extends Command Line... description: Valentina 18.2.1 expands the Valentina Command-Line Interface (vcli) with AI-oriented flags like --ai-schema and --ai-help for schema inspection and SQL... canonical: https://daily.dev/posts/valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support-yo1d3p5nr twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Valentina Release 18.2.1 extends Command Line diagnostics, help and AI support | daily.dev og:description: Valentina 18.2.1 expands the Valentina Command-Line Interface (vcli) with AI-oriented flags like --ai-schema and --ai-help for schema inspection and SQL... og:url: https://daily.dev/posts/valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support-yo1d3p5nr og:image: https://api.daily.dev/og/posts/yO1d3P5NR.png og:image:alt: Valentina Release 18.2.1 extends Command Line diagnostics, help and AI support og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Valentina Release 18.2.1 extends Command Line diagnostics, help and AI support **[Paradigma Software](https://daily.dev/sources/paradigmasoftware)** · [@lynnfredricks](https://daily.dev/lynnfredricks) · 3 min read · 1 upvotes · 0 comments ## Summary Valentina 18.2.1 expands the Valentina Command-Line Interface (vcli) with AI-oriented flags like --ai-schema and --ai-help for schema inspection and SQL guidance, a --read-only mode, native query diagnostics via --warnings and --tunes, named DbMode layouts for database creation, improved pager behavior, and richer shell completions. Valentina Studio 18.2.1 adds colored icon preferences, new AI Python action permission levels (Sandbox, Ask for Approval, Full Access), read-only Form inspection in Ask mode, improved AI-generated Python syntax, and better AI error handling. ## Content Also more prompt options, better Python support and Valentina Forms. See the [Paradigma Software release notes](https://valentina-db.com/docs/dokuwiki/v18/doku.php?id=valentina:releases:18.0:18.2#release_1821) for a complete list of what’s new, improvements, changes and fixes for Valentina Command Line Interface, Valentina Studio and ValentinaDB. ## Valentina CLI Valentina 18.1 introduced the first release of Valentina Command-Line Interface. The vcli command is included with Valentina Studio and Valentina Server packages and provides terminal-based access to local databases and Valentina Server. This update adds: - [New][AI][Schema] Added `–ai-schema` so AI agents can inspect the actual tables, columns, indexes, and constraints before generating SQL. It writes a versioned JSON snapshot for local ValentinaDB, SQLite, and DuckDB databases and for Valentina Server databases. ValentinaDB snapshots also include catalog link metadata and column dimensions. - [New][AI][Help] Added `–ai-help[=]` so AI agents can look up engine-specific SQL guidance before writing queries, without opening a database. It returns a versioned JSON guide with documentation links and task-oriented Valentina SQL cards; SQLite and DuckDB currently return documentation links but no cards. - [New][Connections] Added `–read-only` for existing local ValentinaDB, SQLite, and DuckDB databases. It rejects write operations and cannot be combined with `–create` or remote `–host` connections. - [New][Diagnostics] Added `–warnings` and `–tunes` for native Valentina query diagnostics from commands, SQL files, standard input, and interactive sessions. Diagnostics are written to standard error and are available only with `–engine=valentinadb`. - [Imp][Database creation] `–create` now accepts named native Valentina `DbMode` layouts such as `kDscDatBlbInd`. Existing Boolean values remain supported. SQLite and DuckDB reject named Valentina layouts. - [Imp][Output] On macOS and Linux, `–pager=auto` now starts paging only when interactive output reaches the terminal height or width. `–pager=on` always pages and `–pager=off` prints directly. - [Imp][Shell completion] Generated Bash, Zsh, and PowerShell completions now provide richer value suggestions and option-specific descriptions. - [Imp][Help] `vcli –help` now links to the general Valentina documentation and SQL Reference. ## Valentina Studio Valentina Studio is the popular, free database and data source management suite of tools from Paradigma Software. Valentina Studio PRO adds advanced features to the Studio toolbox, including Report Designer and Forms Designer. In addition to a fresh appearance makeover and native UI integration improvements, Valentina Studio 18.2.1 adds new features: - [New][Appearance] Added **Use colored icons** under **Preferences > Appearance** for supported semantic icon accents. Enabled by default on Windows and disabled by default on macOS and Linux. - [New][AI] Added **Sandbox**, **Ask for Approval**, and **Full Access** choices for AI Python actions. **Sandbox** is the default and restricts selected file, process, network, and system operations, but does not isolate Python from Studio; Agent-mode actions can still change attached objects. - [Imp][AI][Form Editor] In Ask mode, the AI can inspect an attached Form through a read-only copy without modifying the live Form. - [Imp][AI][Python] AI-generated Python now uses native `len(sequence)` and `sequence[index]` syntax for application sequences. - [Imp][AI] Improved cancellation and reset handling and added explanatory errors when an AI provider returns an empty response. See extended release in your own language: [[FORUM](https://valentina-db.com/en/discussions/11829-valentina-release-18-2-1-extends-command-line-diagnostics,-help-and-ai-support)] | [[EN](https://valentina-db.com/en/latest-news/656-valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support)] | [[FR](https://valentina-db.com/fr/latest-news/656-la-version-18-2-1-de-valentina-etend-les-diagnostics-en-ligne-de-commande-l-aide-et-la-prise-en-charge-de-l-ia)] | [[DE](https://valentina-db.com/de/latest-news/656-valentina-release-18-2-1-erweitert-die-diagnosefunktionen-der-befehlszeile-die-hilfe-und-die-ki-unterstuetzung)] | [[IT](https://valentina-db.com/it/latest-news/656-valentina-release-18-2-1-estende-la-diagnostica-da-riga-di-comando-l-aiuto-e-il-supporto-ai)] | [[JP](https://valentina-db.com/jp/latest-news/656-valentina-release-18-2-1-ai)] | [[KO](https://valentina-db.com/ko/latest-news/656-valentina-release-18-2-1-ai)] | [[PL](https://valentina-db.com/pl/latest-news/656-valentina-release-18-2-1-rozszerza-diagnostyke-wiersza-polecen-pomoc-oraz-obsluge-ai)] | [[RU](https://valentina-db.com/ru/latest-news/656-valentina-18-2-1)] | [[ES](https://valentina-db.com/es/latest-news/656-valentina-release-18-2-1-amplia-los-diagnosticos-de-la-linea-de-comandos-la-ayuda-y-el-soporte-de-ia)] ## Similar posts on daily.dev - [Intelligent Terminal 0.1.1 is here: bash support, new slash commands, and more customization](https://daily.dev/posts/intelligent-terminal-0-1-1-is-here-bash-support-new-slash-commands-and-more-customization-dynwiqjyr) · Windows Command Line · 58 upvotes · 7 comments - [Visual Studio 18.5 lands with AI debugging at a price, devs still feeling blue](https://daily.dev/posts/visual-studio-18-5-lands-with-ai-debugging-at-a-price-devs-still-feeling-blue-nhtjdurym) · DEVCLASS · 1 upvotes · 0 comments - [Wing Python IDE Version 11.1](https://daily.dev/posts/wing-python-ide-version-11-1-qot35ngia) · Planet Python · 1 upvotes · 0 comments - [AI power tools: 6 ways to supercharge your terminal](https://daily.dev/posts/ai-power-tools-6-ways-to-supercharge-your-terminal-txighsnc8) · InfoWorld · 1 upvotes · 0 comments - [Visual Studio Code 1.122](https://daily.dev/posts/visual-studio-code-1-122-b4l5d9kcw) · Visual Studio Code · 10 upvotes · 2 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#sqlite](https://daily.dev/tags/sqlite), [#duckdb](https://daily.dev/tags/duckdb) [View this post on daily.dev](https://daily.dev/posts/valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support-yo1d3p5nr) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support-yo1d3p5nr","headline":"Valentina Release 18.2.1 extends Command Line diagnostics, help and AI support","text":"Valentina 18.2.1 expands the Valentina Command-Line Interface (vcli) with AI-oriented flags like --ai-schema and --ai-help for schema inspection and SQL guidance, a --read-only mode, native query diagnostics via --warnings and --tunes, named DbMode layouts for database creation, improved pager behavior, and richer shell completions. Valentina Studio 18.2.1 adds colored icon preferences, new AI Python action permission levels (Sandbox, Ask for Approval, Full Access), read-only Form inspection in Ask mode, improved AI-generated Python syntax, and better AI error handling.","url":"https://daily.dev/posts/valentina-release-18-2-1-extends-command-line-diagnostics-help-and-ai-support-yo1d3p5nr","datePublished":"2026-09-29T16:12:09.618Z","dateModified":"2026-10-12T13:48:25.020Z","author":{"@type":"Person","name":"Lynn Fredricks","url":"https://daily.dev/lynnfredricks","image":"https://media.daily.dev/image/upload/s--RD_nOlcG--/f_auto/v1725028985/avatars/avatar_9IZpn14Ye21pdYIySNTth","description":"Yeah, not an engineer, but I know our industry. ","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"EndorseAction"},"userInteractionCount":5885}},"image":"https://media.daily.dev/image/upload/s--nQP-IWQR--/f_auto/v1790698329/posts/yO1d3P5NR?_a=BAMAMicg0","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/squads/paradigmasoftware","name":"Paradigma Software"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Paradigma Software","item":"https://daily.dev/squads/paradigmasoftware"},{"@type":"ListItem","position":3,"name":"Valentina Release 18.2.1 extends Command Line diagnostics, help and AI support"}]} ```