Frequently asked
questions.
Everything about DataBook Studio, SAYA AI, databases, security, and licensing.
+What is DataBook Studio?
A desktop-native Data IDE and SQL Notebook for PostgreSQL, MySQL, and Snowflake, with an AI copilot called SAYA AI. It gives you a powerful SQL editor, spreadsheet-grade results, and an AI that understands your schema.
+Which platforms does it run on?
macOS (Apple Silicon) and Windows (x64). Builds are MSI and NSIS for Windows, DMG for macOS. The app is a compact, optimized binary.
+Do I need an internet connection?
No. The app runs entirely offline. Database connections are direct. SAYA AI can run locally with no network. You only need connectivity for cloud AI providers or Snowflake SSO auth.
+What can SAYA AI do?
Three modes: Quick Chat (ask anything about your schema), Skills (run one of 6 curated profiling skills), and Goal (give an analysis goal and SAYA plans, runs SQL, and streams results). It reads your schema, runs read-only probes, and returns Markdown reports with runnable SQL blocks.
+Which AI providers are supported?
Claude (Anthropic), OpenAI and OpenAI-compatible endpoints, Gemini (Google), and Ollama for fully local inference. Cloud providers support tool-calling. Ollama runs entirely on-device.
+Can SAYA AI modify my data?
No. Every AI-authored query is validated to ensure only SELECT, SHOW, and EXPLAIN are permitted. DROP, DELETE, and TRUNCATE are blocked before execution. This is enforced per database dialect.
+Does my data get sent to the cloud?
Not unless you enable a cloud provider and turn off privacy mode. By default, schema metadata and search indexes stay local. In enterprise privacy mode, the AI cannot execute queries — it reasons from schema only and authors SQL for you to run.
+Which databases are supported?
PostgreSQL (with connection pooling), MySQL, Snowflake (with SSO, Key-Pair, and User/Password auth), and DuckDB (bundled for local analytics — no external server required).
+How does the Snowflake large result set handling work?
When Snowflake splits large result sets across partition URLs, DataBook Studio handles this transparently — downloading, decompressing, and assembling the complete result set for you with no manual intervention.
+Can I add a new database?
The architecture is designed for extensibility. Adding a new database engine is straightforward — it requires no changes to the rest of the application.
+Where are my credentials stored?
In your operating system's secure credential store — never written to disk or local storage in plaintext. When connection profiles are saved, sensitive fields are automatically stripped.
+Is there an audit log?
Yes. Every AI run is logged locally with mode, target, tool calls, guardrail blocks, rows scanned, and outcome. You can inspect it anytime.
+Is there a free trial?
Yes — every download starts with a 7-day device-bound trial. No account or credit card required. When it ends, read-only browsing (schema, notebooks, saved queries) stays available; running queries and SAYA AI require a license key.
+How do I activate a license?
Open the in-app activation dialog, purchase through our secure payment processor, and paste the issued key. It's verified and bound to your device.