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.2.0 - Latest

New Features:

Auto-qualified table names in queries - Right-click queries now automatically include database prefix (e.g., telegraf.cpu instead of just cpu)
All query generation commands now properly extract database and measurement from tree item metadata

Improvements:

Fixed generateSelectQuery to read metadata.measurement and metadata.database
Fixed queryLastHour, queryToday, showTableSchema, previewData, and showTableStats to use correct metadata
Queries now work without manual editing of database prefix

0.1.9

WARNING - BREAKING CHANGES:

API Endpoints Updated: All Arc API endpoints migrated to /api/v1/... pattern
- Query: /query → /api/v1/query
- Write: /write/v1/msgpack → /api/v1/write/msgpack
- Auth: /auth/* → /api/v1/auth/*
- Measurements: /measurements → /api/v1/measurements
- Metrics: /metrics → /api/v1/metrics
Requires Arc v1.0.0+: This version requires Arc Core v1.0.0 or later
Backwards Incompatible: Will not work with pre-v1.0 Arc servers

What's Changed:

Updated all API client calls to use standardized /api/v1/... endpoints
Improved MessagePack write endpoint to /api/v1/write/msgpack
Updated query endpoints to /api/v1/query and /api/v1/query/arrow
Modernized authentication endpoints to /api/v1/auth/*
Updated CSV import and data generator to use new endpoints

Migration Guide: If you're upgrading from a pre-v1.0 Arc server:

Upgrade Arc Core to v1.0.0 or later
Update this extension to v0.1.9
Reconnect to your Arc server
All existing saved connections and queries will work automatically

Previous Features (still included):

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
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 by Basekick Labs