Data Management

View and edit JSON files and SQLite databases with built-in viewers

Overview

TeamIDE includes specialized viewers for working with structured data:

• JSON Viewer - Table view for JSON arrays with inline editing
• SQLite Browser - Full database browser with query console
• Markdown Embeds - Embed live data tables in documentation

These viewers open automatically when you click a .json, .db, or .sqlite file.

JSON Viewer

When you open a JSON file containing an array, TeamIDE displays it as an editable table.

Table Features

Unsaved Changes

An orange badge appears when you have unsaved changes. Click Save to persist your edits to the file.

JSON Objects

If the JSON file contains an object (not an array), it displays as a formatted read-only tree view.

Value Types

When editing, values are automatically converted: - "true" or "false" → boolean - "123" or "45.67" → number - "null" → null

SQLite Browser

When you open a .db, .sqlite, or .sqlite3 file, TeamIDE displays a full database browser.

Table Navigator

The left sidebar lists all tables in the database: - Click a table name to view its data - Click Refresh to reload the table list

Viewing Data

The main area displays table data with: - Row count badge showing total records - Pagination for large tables (100 rows per page) - Search box - type and press Enter to filter rows

Adding Rows

1. Click + Add Row
2. Fill in the form fields (column types are shown)
3. Primary key fields are marked with “PK”
4. Click Save to insert the row

Editing Rows

1. Click the Edit button on any row
2. Modify fields in the dialog
3. Primary key fields cannot be changed
4. Click Save to update the row

Deleting Rows

1. Click the Delete button on any row
2. Confirm the deletion
3. The row is permanently removed

Schema Inspector

Click View Schema to see the table structure: - Column names and data types - Nullable status - Primary key indicators - Default values

SQL Console

For advanced queries, toggle the SQL Console at the bottom:

1. Click SQL Console to expand
2. Write a SELECT query
3. Press Cmd/Ctrl+Enter or click Run
4. Results display below (up to 100 rows)

Note: Only SELECT queries are allowed in the console. Use the Add/Edit/Delete buttons for data modifications.

Markdown Data Embeds

Embed live data tables directly in your markdown documentation using special fence blocks.

JSON Table Embed

Display data from a JSON file as a table in your markdown:

```json-table
path: data/users.json
columns: id,name,email
search: true
```

Attributes:

SQL Query Embed

Display results from a SQLite query as a table:

```sql-table
path: data/app.db
query: SELECT id, name, email FROM users WHERE active = 1
columns: ID, Name, Email
```

Attributes:

Note: Only SELECT queries are allowed for security.

Embed Features

Embedded tables include: - Refresh button - Reload data from source file - Compact display - Optimized for inline viewing - Live data - Always shows current file contents

Use Cases

• Data dictionaries - Document database schemas
• Sample data - Show example records in docs
• Reports - Embed query results in documentation
• Dashboards - Create data-driven markdown pages

Supported File Types

Tips

Working with Large JSON Files

• Use search to filter to relevant rows
• Sort by clicking column headers
• Add rows at the bottom of the table

SQLite Best Practices

• Use the schema inspector to understand table structure
• Write complex queries in the SQL Console
• Use pagination to navigate large result sets

Effective Embeds

• Keep embedded tables focused (filter columns)
• Use descriptive column headers in SQL embeds
• Add search for tables users need to filter

Related

• Code Module - File explorer and editor
• Markdown Reference - Markdown syntax guide

Changelog