sqlitecloud

A powerful VSCode extension that brings the SQLite Cloud Studio directly into your editor for seamless database management.

Features

• 🎯 Sidebar Integration - Dedicated sidebar for managing all your database connections
• 💾 Connection Management - Save and switch between multiple database connections
• 📑 Multiple Tabs - Work with multiple databases simultaneously in separate tabs
• 🎨 Theme Sync - Automatic theme synchronization with VSCode (light/dark mode)
• 📊 Full Database Management - Complete SQL console, table viewer, and data editing capabilities
• 🔒 Secure Storage - Connection strings stored securely in VSCode
• 📥 Export Support - Download table data as JSON, CSV, or XLSX

Getting Started

1. Add Your First Connection

1. Click the sqlitecloud icon in the Activity Bar (left sidebar)
2. Click the + button to add a new connection
3. Enter a name for your connection (e.g., "Production DB")
4. Enter your SQLite Cloud connection string

2. Connection String Format

Your connection string should look like this:

sqlitecloud://projectId.host.sqlite.cloud:8860/database.sqlite?apikey=YOUR_API_KEY

You can get it from the Dashboard:

1. Click the Connect button in the bottom left
2. Select your Project, User and API Key (the Database can be changed later in the Studio interface)

Don't have a SQLite Cloud account? Sign up here

3. Open Your Database

Click on any connection in the sidebar to open it in a new tab. You can open multiple connections simultaneously.

Usage

Managing Connections

From the Sidebar:

• Open Connection - Click any connection to open it in a new tab
• Add Connection - Click the + button
• Refresh - Click the refresh icon to reload connections
• Right-click menu:
  • Set as Active - Makes this connection the default
  • Edit Connection - Update name or connection string
  • Delete Connection - Remove the connection

From Command Palette (Cmd+Shift+P or Ctrl+Shift+P):

• sqlitecloud: Open - Opens the active connection
• sqlitecloud: Add Connection - Add a new connection

Working with Your Database

Once connected, you can:

• Browse Tables - View all tables and their schemas
• Edit Data - Directly edit table rows
• Run SQL Queries - Execute custom SQL queries via the console
• View Relationships - Explore foreign key relationships
• Export Data - Download table data in multiple formats

Multiple Connections

You can work with multiple databases at once:

• Each connection opens in its own tab
• Tabs remain open when switching between connections
• Each tab maintains an independent database connection
• Close tabs individually as needed

Troubleshooting

"No Connection" message

Add a connection using the + button in the sidebar or run sqlitecloud: Add Connection from the Command Palette.

Connection errors

• Verify your connection string format
• Check that your API key is valid
• Ensure your SQLite Cloud project is accessible
• Check your internet connection (WebSocket support required)

Downloads not working

• Verify you have write permissions to the save location

Support

For issues or questions:

• Visit SQLite Cloud Documentation
• Contact SQLite Cloud Support