llms.txt
Compare with other sites' llms.txt files →# Seaquel
> A fast, offline-first SQL client for Postgres, MySQL, MariaDB, SQLite, SQL Server and DuckDB. Browse schemas, visualize queries, and add AI assistance only when you want it. Available for macOS, Windows and Linux. The source code is MIT licensed; official builds are free for personal use and need a license for work.
The site also hosts a free interactive SQL course (Learn SQL) and a reference of common SQL error messages with fixes, both runnable in the browser.
## Product
- [Features](https://seaquel.app/features): Visual query builder, ERD viewer, schema browser, dashboards, staged edits and an optional AI assistant.
- [Pricing](https://seaquel.app/pricing): Source code is MIT licensed. Official builds are free for personal use; Individual and Business licenses cover commercial use.
- [Download](https://seaquel.app/download): Free for macOS (Apple Silicon & Intel), Windows and Linux, fully functional without an account or license.
- [Public metrics](https://seaquel.app/metrics): Download stats, GitHub activity, release cadence and platform breakdown.
## Learn SQL
- [Getting Started](https://seaquel.app/learn-sql/intro): What SQL actually does, the four tables you'll be querying throughout this course, and your first working query. No setup, no install, no signup.
- [The SELECT Statement](https://seaquel.app/learn-sql/select): Choosing columns, renaming them, computing new ones, removing duplicates and limiting results. Plus the evaluation order that explains most beginner errors.
- [Filtering with WHERE](https://seaquel.app/learn-sql/where): Comparison operators, AND/OR precedence, IN, BETWEEN, LIKE, and the NULL behaviour that makes WHERE quietly drop rows you expected to see.
- [Sorting with ORDER BY](https://seaquel.app/learn-sql/order-by): Sorting on one column or several, ascending and descending, where NULLs land, and why a query without ORDER BY has no guaranteed row order at all.
- [Aggregate Functions](https://seaquel.app/learn-sql/aggregates): COUNT, SUM, AVG, MIN and MAX, the difference between COUNT(*) and COUNT(column), and how aggregates quietly skip NULLs in a way that can skew an average.
- [GROUP BY](https://seaquel.app/learn-sql/group-by): How GROUP BY buckets rows before aggregating, why every non-aggregated column must be grouped, grouping on multiple columns and on expressions.
- [HAVING vs WHERE](https://seaquel.app/learn-sql/having): WHERE filters rows before grouping, HAVING filters groups after. The difference, when each one is correct, and why using the wrong one changes your numbers.
- [SQL Joins](https://seaquel.app/learn-sql/joins): INNER, LEFT, RIGHT and FULL joins with working examples, plus the two mistakes that quietly corrupt results: filtering a LEFT JOIN in WHERE, and row fan-out.
- [Subqueries](https://seaquel.app/learn-sql/subqueries): Queries inside queries: scalar subqueries, IN and EXISTS, correlated subqueries, and the NOT IN behaviour with NULLs that returns zero rows for no obvious reason.
- [Common Table Expressions](https://seaquel.app/learn-sql/cte): WITH turns nested subqueries into named steps you read top to bottom. Chaining CTEs, when they help, when they hurt performance, and a short note on recursion.
- [Window Functions](https://seaquel.app/learn-sql/window): OVER, PARTITION BY and ORDER BY, the difference between ROW_NUMBER, RANK and DENSE_RANK, running totals, LAG and LEAD, and how to filter on a window result.
- [The Practice Database](https://seaquel.app/learn-sql/sandbox): The full schema and sample data behind this course, a set of exercises from easy to hard, and a sandbox to run any query you like against it.
## SQL errors
- [aggregate function calls cannot be nested](https://seaquel.app/sql-errors/aggregate-function-calls-cannot-be-nested): Why AVG(COUNT(*)) and MAX(SUM(x)) fail, and how to aggregate an aggregate with a subquery, a CTE or a window function.
- [aggregate functions are not allowed in WHERE](https://seaquel.app/sql-errors/aggregate-functions-not-allowed-in-where): Why COUNT, SUM and AVG can't go in WHERE, when to move the condition to HAVING, and how to compare rows against an aggregate with a subquery.
- [column "x" does not exist](https://seaquel.app/sql-errors/column-does-not-exist): Why PostgreSQL can't find a column that's right there in your SELECT: aliases used in WHERE, double-quoted strings, and case-sensitive quoted identifiers.
- [column "x" must appear in the GROUP BY clause or be used in an aggregate function](https://seaquel.app/sql-errors/column-must-appear-in-group-by): Why PostgreSQL rejects a column in SELECT that isn't grouped or aggregated, the MySQL only_full_group_by equivalent, and three ways to fix it.
- [column reference "x" is ambiguous](https://seaquel.app/sql-errors/column-reference-is-ambiguous): Why a join makes an unqualified column like id ambiguous, how table aliases fix it, and what MySQL, SQL Server and SQLite call the same error.
- [division by zero](https://seaquel.app/sql-errors/division-by-zero): Why PostgreSQL and SQL Server stop on a zero divisor while MySQL, SQLite and DuckDB return NULL, and how NULLIF makes averages and ratios safe.
- [each UNION query must have the same number of columns](https://seaquel.app/sql-errors/each-union-query-must-have-the-same-number-of-columns): Why UNION needs both queries to return the same number of columns with compatible types, how to line them up, and when to use UNION ALL instead.
- [for SELECT DISTINCT, ORDER BY expressions must appear in select list](https://seaquel.app/sql-errors/select-distinct-order-by-must-appear-in-select-list): Why PostgreSQL won't sort DISTINCT results by a column you didn't select, and how to get the order you meant with GROUP BY and an aggregate.
- [invalid input syntax for type integer: "x"](https://seaquel.app/sql-errors/invalid-input-syntax-for-type-integer): Why PostgreSQL rejects a string compared with or cast to an integer column, including the empty-string case, and how to fix the query or clean the input.
- [missing FROM-clause entry for table "x"](https://seaquel.app/sql-errors/missing-from-clause-entry-for-table): What PostgreSQL means by a missing FROM-clause entry: an alias you never defined, a table you never joined, or a table name used after aliasing it.
- [more than one row returned by a subquery used as an expression](https://seaquel.app/sql-errors/more-than-one-row-returned-by-subquery): Why a subquery after = or inside SELECT must return a single row, why the query worked yesterday, and how to fix it with IN, an aggregate or LIMIT 1.
- [operator does not exist: character varying = integer](https://seaquel.app/sql-errors/operator-does-not-exist): PostgreSQL won't compare text to a number without a cast. Usually the join or filter is on the wrong column. Sometimes a cast is the right fix.
- [relation "x" does not exist](https://seaquel.app/sql-errors/relation-does-not-exist): The table exists, but PostgreSQL can't find it. Usually the cause is a schema missing from search_path, a quoted mixed-case name, or the wrong database.
- [window functions are not allowed in WHERE](https://seaquel.app/sql-errors/window-functions-not-allowed-in-where): Why you can't filter on ROW_NUMBER or RANK in WHERE, how to wrap the query in a subquery or CTE to get the top row per group, and where QUALIFY works.
- [PostgreSQL error codes](https://seaquel.app/sql-errors/postgresql): All 262 PostgreSQL error codes, each with its own page.
- [MySQL error codes](https://seaquel.app/sql-errors/mysql): All 1,855 MySQL error codes, each with its own page.
- [SQLite error codes](https://seaquel.app/sql-errors/sqlite): All 105 SQLite error codes, each with its own page.
- [SQL Server error codes](https://seaquel.app/sql-errors/sql-server): All 4,282 SQL Server error codes, each with its own page.
## Docs
- [Creating Connections](https://seaquel.app/docs/connections/creating-connections/): Learn how to create, configure, and test database connections in Seaquel, with secure local keychain storage and no cloud required.
- [DuckDB](https://seaquel.app/docs/connections/duckdb/): Connect to DuckDB for fast embedded analytics in Seaquel. Run queries on local database files or spin up an in-memory database instantly.
- [Importing Connections](https://seaquel.app/docs/connections/importing/): Migrate to Seaquel by importing your existing connections from DBeaver and TablePlus in just a few clicks — no manual re-entry required.
- [Microsoft SQL Server](https://seaquel.app/docs/connections/mssql/): Connect to Microsoft SQL Server and Azure SQL databases in Seaquel. Configure host, port, authentication, and optional SSL encryption.
- [MySQL](https://seaquel.app/docs/connections/mysql/): Connect to MySQL and MariaDB databases in Seaquel. Both database types use the same connection type with host, port, and credential settings.
- [PostgreSQL](https://seaquel.app/docs/connections/postgresql/): Connect to PostgreSQL databases in Seaquel. Configure host, port, credentials, SSL, and connection strings for local or remote servers.
- [Projects](https://seaquel.app/docs/connections/projects/): Organize your database connections into projects in Seaquel. Group connections by team, client, or application and switch between them easily.
- [SQLite](https://seaquel.app/docs/connections/sqlite/): Open and query SQLite database files in Seaquel. No server needed — just pick a .db or .sqlite file and connect instantly on your local machine.
- [SSH Tunnels](https://seaquel.app/docs/connections/ssh-tunnels/): Connect to remote databases through SSH tunnels in Seaquel. Reach databases behind firewalls, private networks, or bastion jump servers securely.
- [SSL / TLS](https://seaquel.app/docs/connections/ssl-tls/): Configure SSL/TLS encryption for your database connections in Seaquel. Choose from disable, allow, prefer, require, or verify-full SSL modes.
- [AI Assistant](https://seaquel.app/docs/customization/ai-assistant/): Use Seaquel's AI assistant to write SQL with plain English prompts. It understands your schema and generates queries tailored to your data.
- [Command Palette](https://seaquel.app/docs/customization/command-palette/): Open the command palette with Cmd+K to instantly access commands, navigate connections, and search across all of Seaquel's features.
- [Keyboard Shortcuts](https://seaquel.app/docs/customization/keyboard-shortcuts/): Complete keyboard shortcut reference for Seaquel, covering editor actions, navigation, connections, and more — for Mac, Windows, and Linux.
- [Language](https://seaquel.app/docs/customization/language/): Switch Seaquel's interface language to English, German, French, Spanish, Arabic, or Korean — all UI text and messages are fully translated.
- [Themes](https://seaquel.app/docs/customization/themes/): Personalize Seaquel with 20 built-in light and dark theme presets, or create a custom theme that switches automatically with your system.
- [Updates](https://seaquel.app/docs/customization/updates/): Keep Seaquel up to date with automatic background update checks. Review release notes and install new versions with a single click.
- [Executing Queries](https://seaquel.app/docs/editor/executing-queries/): Run SQL queries with a keyboard shortcut and instantly view results, execution time, and row counts in the result grid.
- [Formatting](https://seaquel.app/docs/editor/formatting/): Instantly auto-format and clean up messy SQL with a single keyboard shortcut, keeping your queries consistent and readable.
- [Query Parameters](https://seaquel.app/docs/editor/query-parameters/): Use double curly brace template variables to write reusable, parameterized SQL queries with values filled in at execution time.
- [Sample Queries](https://seaquel.app/docs/editor/sample-queries/): Explore your data immediately with built-in sample queries covering SELECTs, JOINs, aggregations, and CTEs for every supported database type.
- [Tabs](https://seaquel.app/docs/editor/tabs/): Work across multiple queries at once using tabs you can rename, reorder, and switch between quickly using keyboard shortcuts.
- [Writing Queries](https://seaquel.app/docs/editor/writing-queries/): Write SQL in a Monaco-powered editor with schema-aware autocomplete, syntax highlighting, and code folding for all supported databases.
- [Installation](https://seaquel.app/docs/getting-started/installation/): Download and install Seaquel on macOS, Windows, or Linux — a lightweight desktop app built with Tauri, no Docker or Java required.
- [Interface Overview](https://seaquel.app/docs/getting-started/interface-overview/): A tour of the Seaquel interface covering the sidebar, schema browser, Monaco query editor, results grid, and multi-tab workflow.
- [Quick Start](https://seaquel.app/docs/getting-started/quick-start/): Connect to a database and run your first SQL query in under 5 minutes. Supports PostgreSQL, MySQL, SQLite, DuckDB, and MSSQL.
- [Practice Database](https://seaquel.app/docs/learn-sql/practice-database/): Seaquel includes a built-in e-commerce sample database with users, products, orders, and more — no setup or data import needed.
- [Query Builder](https://seaquel.app/docs/learn-sql/query-builder/): Build SQL queries visually with a drag-and-drop canvas. Add tables, draw joins, set filters, and Seaquel generates the SQL in real time.
- [Tutorials](https://seaquel.app/docs/learn-sql/tutorials/): Learn SQL interactively with Seaquel's built-in curriculum — progressive lessons from basics to advanced, running against a practice database.
- [Query History](https://seaquel.app/docs/organization/query-history/): Automatically browse and search your recent queries with full SQL text, timestamps, execution times, and row counts per entry.
- [Saved Queries](https://seaquel.app/docs/organization/saved-queries/): Save, name, and organize frequently used queries per connection so you can find and re-run them from the sidebar anytime.
- [Shared Library](https://seaquel.app/docs/organization/shared-library/): Share SQL queries across your team through Git-synced repositories with full version control and branch-based collaboration.
- [Editing Data](https://seaquel.app/docs/results/editing-data/): Click any cell in the result grid to edit its value inline — Seaquel generates and runs the UPDATE statement automatically for you.
- [Exporting Data](https://seaquel.app/docs/results/exporting/): Export query results to CSV, JSON, SQL insert statements, or Markdown tables to use in spreadsheets, scripts, or documentation.
- [Row Operations](https://seaquel.app/docs/results/row-operations/): Perform full CRUD operations from the result grid — insert, update, and delete rows using guided dialogs without writing SQL by hand.
- [Viewing Results](https://seaquel.app/docs/results/viewing-results/): Browse query results in a responsive grid with virtual scrolling, sortable and resizable columns, and support for large result sets.
- [Schema Browser](https://seaquel.app/docs/schema/schema-browser/): Navigate your database schema using the sidebar tree, which lists every schema, table, view, and row count at a glance.
- [Statistics](https://seaquel.app/docs/schema/statistics/): Monitor database size, table metrics, and index usage to find optimization opportunities without writing diagnostic queries.
- [Table Inspector](https://seaquel.app/docs/schema/table-inspector/): View detailed column information including types, nullability, defaults, primary keys, foreign keys, indexes, and constraints.
- [Canvas](https://seaquel.app/docs/visual-tools/canvas/): Build analysis workflows on an infinite visual canvas by connecting table, query, chart, and note nodes into pipelines.
- [Charts](https://seaquel.app/docs/visual-tools/charts/): Turn query results into bar, line, pie, and scatter charts instantly — map your columns and visualize data without leaving the app.
- [ERD Viewer](https://seaquel.app/docs/visual-tools/erd-viewer/): Generate an interactive Entity Relationship Diagram from your live database schema, showing tables, columns, and foreign keys.
- [Query Plans](https://seaquel.app/docs/visual-tools/query-plans/): Visualize EXPLAIN and EXPLAIN ANALYZE output as interactive tree diagrams to find bottlenecks and optimize query performance.
- [Query Visualizer](https://seaquel.app/docs/visual-tools/query-visualizer/): Parse and visualize SQL queries as interactive diagrams that clearly show tables, joins, filters, and column relationships.
## Comparisons
- [Seaquel vs Azure Data Studio](https://seaquel.app/compare/azure-data-studio): A sourced comparison of Seaquel and Azure Data Studio, which Microsoft retired on 28 February 2026: what ADS did, what Seaquel can and can't replace, and when VS Code is the better move.
- [Seaquel vs Beekeeper Studio](https://seaquel.app/compare/beekeeper-studio): A sourced comparison of Seaquel and Beekeeper Studio: two open-source SQL clients with similar positioning, and the places they genuinely diverge.
- [Seaquel vs DataGrip](https://seaquel.app/compare/datagrip): A sourced comparison of Seaquel and JetBrains DataGrip: current pricing, the free non-commercial tier, and why DataGrip's SQL editor is still the best in the category.
- [Seaquel vs DBeaver](https://seaquel.app/compare/dbeaver): A sourced comparison of Seaquel and DBeaver: what the free Community edition actually includes, what the paid tiers cost, and where DBeaver is the stronger tool.
- [Seaquel vs TablePlus](https://seaquel.app/compare/tableplus): A sourced comparison of Seaquel and TablePlus: pricing, supported engines, Linux release cadence, and the things TablePlus does better.
- [Azure Data Studio alternative](https://seaquel.app/alternatives/azure-data-studio): Microsoft retired Azure Data Studio in February 2026. Here's what replaces it on macOS and Linux, including the parts of SQL Server work Seaquel doesn't handle yet.
- [DBeaver alternative](https://seaquel.app/alternatives/dbeaver): Looking for a lighter DBeaver? Here's an honest look at what you gain, what you give up, and how to bring your connections across.
- [TablePlus alternative](https://seaquel.app/alternatives/tableplus): Looking to replace TablePlus? Here's where Seaquel fits, where TablePlus is still the better tool, and how to import your connections.
- [TablePlus alternative for Linux](https://seaquel.app/alternatives/tableplus-on-linux): TablePlus on Linux ships on its own slower release line. Here's exactly what it's missing as of September 2026, and where Seaquel fits.
## Blog
- [Put a Run Button on the SQL in Your Blog Posts](https://seaquel.app/blog/run-sql-in-your-blog-posts): A free embed that turns the SQL in your blog posts into real Postgres queries readers can edit and run without leaving the page.
- [Welcome to the Seaquel Blog](https://seaquel.app/blog/welcome-to-the-seaquel-blog): Why I'm starting a blog, what you can expect from it, and how it fits alongside the changelog.
## Optional
- [Changelog: Release 2026.9.2](https://seaquel.app/changelog/2026.9.2): 2026-09-20
- [Changelog: Release 2026.9.1](https://seaquel.app/changelog/2026.9.1): 2026-09-20
- [Changelog: Release 2026.4.8](https://seaquel.app/changelog/2026.4.8): 2026-04-15
- [Changelog: Release 2026.4.7](https://seaquel.app/changelog/2026.4.7): 2026-04-09
- [Changelog: Release 2026.4.6](https://seaquel.app/changelog/2026.4.6): 2026-04-07
- [Changelog: Release 2026.4.5](https://seaquel.app/changelog/2026.4.5): 2026-03-27
- [Changelog: Release 2026.4.4](https://seaquel.app/changelog/2026.4.4): 2026-03-07
- [Changelog: Release 2026.4.3](https://seaquel.app/changelog/2026.4.3): 2026-02-21
- [Changelog: Release 2026.4.2](https://seaquel.app/changelog/2026.4.2): 2026-02-16
- [Changelog: Release 2026.4.1](https://seaquel.app/changelog/2026.4.1): 2026-02-16
- [Full changelog](https://seaquel.app/changelog)
- [About](https://seaquel.app/about)
- [Privacy policy](https://seaquel.app/privacy)
- [Terms](https://seaquel.app/terms)