SQL

Connect to relational databases, run queries, and inspect results inside Clauge — no separate database client needed.

Create and manage connections, write SQL with syntax highlighting, and review query results directly in the workspace. Queries run in tabs, so you can keep several tasks open at once.

Create a connection

Click New Connection and enter the details for your database:

• Name — a friendly label, such as Production DB.
• Type — the database engine (PostgreSQL, MySQL, SQLite, and more).
• Host and Port — the database server address and port (defaults are provided).
• Database — the database name.
• Username and Password — the credentials to access the database.
• Optional SSL / SSH — certificates or an SSH tunnel when required.

Click Test to verify the connection, then Save to add it to your list.

Browse and run queries

Open a connection. You’ll see every database on that connection.

From there:

1. Click a database to open it and see its tables.
2. Click a table to see its columns.
3. Double-click a table to open a tab for that table, then write and run a query.
4. Double-click a database to open an SQL editor tab.

Results show in a grid below the editor. You can sort or filter them, keep several query tabs open, and Clauge highlights errors if a query fails.

AI Assistant

In the top-right, click the sparkle icon to open the AI Assistant (tagged SQL). Describe what you want in plain language — no SQL required.

You can use it to:

• Insert, update, or delete rows (CRUD)
• Look up or summarize data
• Ask follow-up prompts; the assistant keeps the current database and table in mind

Keyboard shortcuts

Manage connections

All saved connections are listed in the Connections view, with a search field above the list.

• Open — click a connection to see the databases on that connection.
• Edit — update the connection details when your server or credentials change.
• Delete — remove a connection when it is no longer needed.