Arc Database Manager for VS Code

Complete development toolkit for Arc Database - the high-performance time-series data warehouse.

Features

🔌 Connection Management

Multiple saved connections with secure token storage
Quick connection switching
Connection health monitoring
Visual status indicators in sidebar and status bar

📊 Query Execution

SQL IntelliSense with auto-completion for tables, columns, and DuckDB functions
Execute queries with Ctrl+Enter / Cmd+Enter
Interactive results view with:
- Export to CSV, JSON, or Markdown
- Automatic chart visualization for time-series data
- Table sorting and filtering
- Execution time and row count statistics

📓 Arc Notebooks

Mix SQL and Markdown in a single document (.arcnb files)
Execute cells individually or all at once
Parameterized queries with variable substitution
Export notebooks to Markdown with results
Auto-save functionality

Example Notebook:

# CPU Analysis

Variables:
- interval = 1 HOUR
- threshold = 80

SELECT AVG(usage_user) as avg_cpu
FROM telegraf.cpu
WHERE time > now() - INTERVAL ${interval}
  AND usage_user > ${threshold};

🗂️ Schema Explorer

Browse databases and tables in sidebar
Right-click context menus for:
- Show table schema
- Preview data (first 100 rows)
- Show table statistics
- Generate SELECT queries
- Quick time filters (last hour, today)

📥 Data Ingestion

CSV Import with guided wizard
- Auto-detect delimiters and headers
- Timestamp column selection
- Batch processing for large files
- Uses high-performance MessagePack columnar format
Bulk Data Generator with 5 presets:
- CPU Metrics
- Memory Metrics
- Network Metrics
- IoT Sensor Data
- Custom schemas

🔔 Alerting & Monitoring

Create alerts based on query results
5 condition types: greater than, less than, equals, not equals, contains
Configurable check intervals (minimum 10 seconds)
Desktop notifications when alerts trigger
Alert history tracking
Enable/disable alerts without deletion

Example Alert:

Name: High CPU Usage
Query: SELECT AVG(usage_user) FROM cpu WHERE time > now() - INTERVAL 5 MINUTE
Condition: greater_than
Threshold: 80
Interval: 60s

💾 Query Management

Automatic query history - every query is logged
Saved queries - bookmark frequently used queries
View execution time, row counts, and errors
Quick re-run from history

🔑 Token Management

Create, rotate, and delete server tokens
Verify token validity
Secure storage in system keychain
Visual token management in sidebar

🎨 Dark Mode Support

Automatic theme detection - adapts to VS Code theme
Works with Light, Dark, and High Contrast themes
Theme-aware charts and visualizations
No configuration needed

Quick Start

1. Install the Extension

Search for "Arc Database Manager" in VS Code Extensions marketplace.

2. Connect to Arc Server

Click "Arc: Not Connected" in the status bar
Enter connection details:
- Name: My Arc Server
- Host: localhost
- Port: 8000
- Protocol: http or https
Enter authentication token

3. Start Querying

Press Ctrl+Shift+P → Arc: New Query
Write your SQL query
Press Ctrl+Enter / Cmd+Enter to execute

Requirements

VS Code: 1.85.0 or higher
Arc Database: Running instance accessible via HTTP/HTTPS
Authentication Token: From your Arc server

Extension Settings

This extension contributes the following settings:

arc.defaultHost: Default Arc server host (default: localhost)
arc.defaultPort: Default Arc server port (default: 8000)
arc.defaultProtocol: Default protocol (default: http)

Keyboard Shortcuts

Command	Windows/Linux	macOS
Execute Query	`Ctrl+Enter`	`Cmd+Enter`
New Query	`Ctrl+Shift+P` → Arc: New Query	`Cmd+Shift+P` → Arc: New Query

Commands

Access via Command Palette (Ctrl+Shift+P / Cmd+Shift+P):

Connection:

Arc: Connect to Server
Arc: Disconnect

Queries:

Arc: New Query
Arc: Execute Query
Arc: Save Current Query

Notebooks:

Arc: New Notebook

Data:

Arc: Import CSV
Arc: Generate Test Data

Alerts:

Arc: Create Alert

Explorer:

Arc: Refresh Explorer
Arc: Show Table Schema
Arc: Preview Table Data

See full command list in documentation

Use Cases

Development & Testing

-- Generate test data
Arc: Generate Test Data → CPU Metrics → 100,000 rows

-- Query the data
SELECT
  time_bucket('5 minutes', time) as bucket,
  AVG(usage_user) as avg_cpu
FROM telegraf.cpu
WHERE time > now() - INTERVAL 1 HOUR
GROUP BY bucket
ORDER BY bucket DESC;

Data Analysis in Notebooks

Create .arcnb files with:

Documentation in Markdown
Parameterized SQL queries
Inline results and visualizations
Export to Markdown reports

Production Monitoring

Alert: High Memory Usage
Query: SELECT AVG(used_percent) FROM mem WHERE time > now() - INTERVAL 5 MINUTE
Condition: > 90
Interval: 60s
→ Get notified when memory exceeds 90%

Data Migration

Arc: Import CSV
→ Select your CSV file
→ Configure mapping
→ Import directly to Arc

Performance

Query Results: Displays up to 1,000 rows instantly
CSV Import: ~50,000-100,000 rows/second using MessagePack columnar format
Data Generator: ~100,000-200,000 rows/second
Batch Processing: Handles millions of rows with progress tracking

Documentation

Complete Feature Guide - All features with examples
Dark Mode Guide - Theme customization
Arc Database Docs - Main Arc documentation

Examples

Time-Series Analysis

-- 5-minute moving average
SELECT
  time,
  usage_user,
  AVG(usage_user) OVER (
    ORDER BY time
    ROWS BETWEEN 5 PRECEDING AND CURRENT ROW
  ) as moving_avg
FROM telegraf.cpu
WHERE host = 'server01'
  AND time > now() - INTERVAL 24 HOUR
ORDER BY time DESC;

Parameterized Notebook Query

Variables:
- database = telegraf
- measurement = cpu
- interval = 6 HOUR

SELECT * FROM ${database}.${measurement}
WHERE time > now() - INTERVAL ${interval}
LIMIT 100;

Troubleshooting

Cannot connect to Arc server

Verify Arc is running: curl http://localhost:8000/health
Check host and port are correct
Ensure token is valid: Run Arc: Verify Token

Query timeout

Add time filters: WHERE time > now() - INTERVAL 1 HOUR
Add LIMIT clause
Check Arc server performance

Import fails

Verify CSV encoding is UTF-8
Check delimiter is correct
Try smaller file first to test

More troubleshooting

Release Notes

0.1.9 - Latest

What's New:

✅ Extension fully working - all commands registered and functional
✅ Runtime dependencies properly bundled in VSIX package
✅ Connection to Arc servers working correctly
✅ Activity bar icon displaying properly

Key Changes:

🎨 Arc logo icon in activity bar and extensions list
🔧 Activation event set to onStartupFinished
📦 Runtime dependencies (axios, @msgpack/msgpack) included in package
🛡️ Comprehensive error handling for better debugging

0.1.8

Critical Fix:

🐛 FIXED: Commands not registered - Removed node_modules/** from .vscodeignore so runtime dependencies (axios, @msgpack/msgpack) are included in VSIX package
🐛 Extension now properly activates and all commands work correctly

Bug Fixes:

🐛 Changed activation event to onStartupFinished for reliable loading
🐛 Added comprehensive error handling to catch activation failures
🐛 Fixed activity bar icon to use PNG format

Improvements:

🎨 Better activation event handling
📊 Detailed error messages in Developer Console for debugging

0.1.7

Bug Fixes:

🐛 Fixed "no data provider registered" error that prevented extension from activating
🐛 Fixed activity bar icon - now shows correct Arc logo (PNG) instead of cylinder
🐛 Removed overly broad try-catch that was breaking provider registration

Improvements:

🎨 Updated activity bar icon to use PNG format with Arc logo
🎨 Icon now properly displays in VS Code activity bar and extensions list

0.1.6

Bug Fixes:

🐛 Fixed connection error handling with detailed error messages
🐛 Updated extension icon to proper 128x128 size
🐛 Added extensive logging for debugging connection issues
🐛 Improved error messages for common connection failures (ECONNREFUSED, ENOTFOUND, timeouts)

Improvements:

📊 Better error reporting in Developer Console
🔍 Enhanced debugging with [ArcClient] prefixed logs

0.1.5

Improvements:

🔧 Improved error handling infrastructure

0.1.4

New Features:

✨ Parameterized queries with variables in notebooks
✨ CSV import with MessagePack columnar format
✨ Bulk data generator with 5 presets
✨ Alerting and monitoring system
✨ Notebook export to Markdown
✨ Dark mode support

Improvements:

🚀 25-35% faster data ingestion
🎨 Enhanced notebook UI
📊 Auto-chart detection
🔔 Desktop notifications

Bug Fixes:

🐛 Fixed schema queries
🐛 Fixed notebook cell editing
🐛 Improved error handling

Support

Documentation: Feature Guide
Issues: GitHub Issues
Discussions: GitHub Discussions

License

MIT License

Enjoy using Arc Database Manager! ⚡

Made with ❤️ by Basekick Labs