Personal Preferences

Customize your Slateo experience with personal preferences for editor behavior, default databases, and workspace settings.

Overview

Personal preferences control how Slateo behaves for you specifically. These settings don't affect other users in your organization and can be adjusted at any time to match your workflow.

Access preferences by clicking your profile picture in the navigation bar and selecting Preferences.

Editor preferences

Customize the SQL editor to match your coding style and preferences.

Vim mode

Enable Vim keybindings in the SQL editor for efficient keyboard-driven editing.

Enable Vim mode:

1. Click your profile picture and select Preferences
2. Toggle on Vim mode
3. The SQL editor will immediately use Vim keybindings

Vim mode features:

• Normal, Insert, and Visual modes
• Standard Vim navigation (h, j, k, l)
• Text objects and motions
• Common Vim commands (dd, yy, p, u, etc.)
• Search and replace with / and :%s

Common Vim commands in Slateo:

Command	Action
i	Enter insert mode
Esc	Return to normal mode
dd	Delete line
yy	Copy line
p	Paste
u	Undo
Ctrl-r	Redo
/pattern	Search forward
n	Next search result
:%s/old/new/g	Replace all

Editor theme

The SQL editor theme follows your system or workspace theme preference. To change the editor appearance:

1. Navigate to Preferences
2. Select Display settings
3. Choose your preferred theme (applies to the entire interface including the editor)

Font size

Adjust the editor font size for better readability:

1. Navigate to Preferences
2. Go to Editor settings
3. Select your preferred font size:
   • Small (12px)
   • Medium (14px) - Default
   • Large (16px)
   • Extra large (18px)

Tab behavior

Configure how the Tab key behaves in the SQL editor:

1. Navigate to Preferences > Editor settings
2. Choose Tab behavior:
   • Insert spaces: Tab inserts spaces (default: 2 spaces)
   • Insert tab character: Tab inserts a tab character
3. Set Tab size (2, 4, or 8 spaces)

Default database

Set a default database configuration to streamline query creation. When you create a new query, it will automatically connect to your default database.

Set default database

1. Click your profile picture and select Preferences
2. Navigate to Default database
3. Choose from your organization's configured databases:
   • Redshift clusters
   • Snowflake warehouses
   • BigQuery projects
   • PostgreSQL databases
   • Other connected data warehouses

Your default database is used when:

• Creating new queries
• Opening the SQL editor
• Using quick query shortcuts

Override default database

You can always override the default database for individual queries:

1. Open a query
2. Click the database selector in the top toolbar
3. Choose a different database configuration

The override applies only to that specific query and doesn't change your default preference.

No default database

If you don't set a default database, you'll be prompted to select one each time you create a new query. This is useful if you frequently work across multiple databases.

Codebase connection

Connect your local codebase to enable advanced features like code search, repository browsing, and AI-powered code analysis.

Connect a codebase

Prerequisites:

• Slateo desktop application installed
• Local git repository cloned on your machine
• Read access to the repository

Steps:

1. Open Slateo desktop application
2. Click your profile picture and select Preferences
3. Navigate to Codebase connection
4. Click Connect codebase
5. Browse to your local repository directory
6. Select the repository root folder
7. Click Connect

Slateo will index your codebase and enable features like:

• Code search across files
• Repository file browsing
• AI-powered code explanations
• Query-to-code linking

Manage codebase connection

View connection status:

Your preferences show:

• Connected repository name
• Local path
• Last indexed timestamp
• Index status (up to date, indexing, error)

Update codebase path:

If you move your repository to a new location:

1. Navigate to Preferences > Codebase connection
2. Click Change path
3. Browse to the new location
4. Click Update

Slateo will re-index the codebase at the new location.

Disconnect codebase:

To disconnect your codebase:

1. Navigate to Preferences > Codebase connection
2. Click Disconnect
3. Confirm the action

Disconnecting removes the index but doesn't delete any local files.

Codebase indexing

Slateo automatically indexes your codebase to enable search and analysis features.

What is indexed:

• Source code files (.js, .ts, .py, .sql, etc.)
• Configuration files
• README and documentation
• Git history and branches

What is not indexed:

• node_modules and dependency directories
• Build artifacts and compiled files
• Binary files and media
• Files in .gitignore

Indexing frequency:

Slateo re-indexes your codebase:

• When you first connect
• When you pull new changes
• When you switch branches
• Automatically every 4 hours (if changes detected)

You can manually trigger re-indexing by clicking Re-index now in your codebase connection settings.

Privacy and security

Local processing:

• Codebase indexing happens locally on your machine
• No source code is uploaded to Slateo servers
• Only metadata and search indices are stored

AI features:

• When using AI-powered code analysis, relevant code snippets may be sent to AI providers
• You can disable AI features in Preferences > AI settings
• Review your organization's data processing policies for details

Display settings

Customize the visual appearance of Slateo to match your preferences and work environment.

Theme

Choose between light and dark themes, or follow your system preference:

1. Navigate to Preferences > Display settings
2. Select your preferred theme:
   • Light: Bright interface optimized for well-lit environments
   • Dark: Dark interface to reduce eye strain
   • System: Automatically match your operating system theme

Theme changes apply immediately across the entire Slateo interface.

Sidebar behavior

Configure how the navigation sidebar behaves:

1. Navigate to Preferences > Display settings
2. Choose Sidebar behavior:
   • Always visible: Sidebar is always shown (default)
   • Auto-hide: Sidebar collapses when not in use
   • Collapsed by default: Sidebar starts collapsed, expand with hover or click

Density

Adjust the interface density to show more or less information:

1. Navigate to Preferences > Display settings
2. Select Density:
   • Comfortable: More spacing, larger click targets (default)
   • Compact: Denser layout, more information visible
   • Cozy: Balanced spacing

Density affects:

• Table row heights
• Sidebar item spacing
• Button and input sizes
• Modal and panel layouts

Date and time format

Customize how dates and times are displayed:

1. Navigate to Preferences > Display settings
2. Configure:
   • Date format: MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD
   • Time format: 12-hour or 24-hour
   • Timezone: Your local timezone or UTC

These settings affect:

• Query execution timestamps
• Comment timestamps
• Data refresh schedules
• Activity logs

Keyboard shortcuts

Slateo provides keyboard shortcuts to speed up common actions. Shortcuts are organized by context and can be customized.

View shortcuts

Press ? or Cmd/Ctrl + / anywhere in Slateo to view the keyboard shortcuts panel.

Global shortcuts

These shortcuts work throughout Slateo:

Shortcut	Action
Cmd/Ctrl + K	Open command palette
Cmd/Ctrl + N	Create new query
Cmd/Ctrl + P	Quick search queries
Cmd/Ctrl + /	Show keyboard shortcuts
Cmd/Ctrl + ,	Open preferences
Cmd/Ctrl + Shift + D	Toggle dark mode
Esc	Close modal or panel

Query editor shortcuts

When focused in the SQL editor:

Shortcut	Action
Cmd/Ctrl + Enter	Execute query
Cmd/Ctrl + S	Save query
Cmd/Ctrl + Shift + F	Format SQL
Cmd/Ctrl + D	Duplicate line
Cmd/Ctrl + /	Toggle comment
Cmd/Ctrl + F	Find in query
Cmd/Ctrl + H	Find and replace
Alt + Up/Down	Move line up/down
Cmd/Ctrl + Z	Undo
Cmd/Ctrl + Shift + Z	Redo

Navigation shortcuts

Navigate between views and sections:

Shortcut	Action
G then H	Go to home
G then Q	Go to queries
G then D	Go to databases
G then S	Go to settings
Cmd/Ctrl + [	Go back
Cmd/Ctrl + ]	Go forward

Results table shortcuts

When viewing query results:

Shortcut	Action
Arrow keys	Navigate cells
Tab	Next cell
Shift + Tab	Previous cell
Cmd/Ctrl + C	Copy cell value
Cmd/Ctrl + Shift + C	Copy row as JSON
Cmd/Ctrl + A	Select all rows
Space	Toggle row selection

Customize shortcuts

To customize keyboard shortcuts:

1. Navigate to Preferences > Keyboard shortcuts
2. Find the action you want to customize
3. Click the current shortcut
4. Press your desired key combination
5. Click Save

Reset shortcuts

To reset all shortcuts to defaults:

1. Navigate to Preferences > Keyboard shortcuts
2. Click Reset to defaults
3. Confirm the action

Export shortcuts

Export your custom shortcuts to share with team members or backup:

1. Navigate to Preferences > Keyboard shortcuts
2. Click Export shortcuts
3. Save the JSON file

To import shortcuts:

1. Navigate to Preferences > Keyboard shortcuts
2. Click Import shortcuts
3. Select the JSON file
4. Confirm the import