CodeDB is a macOS desktop application that combines a code editor with a relational database. It lets you store code files, define relationships between them, tag and annotate them with properties, and query everything with SQL.
CodeDB stores all data in a SQLite database at:
~/Library/Application Support/CodeDB/relationcode.db
Your files, relations, tags, properties, and Smart Views are all stored in this single database file.
Yes. You can copy the database file directly, or use the Query Console to export data as JSON or CSV.
CodeDB supports syntax highlighting for 20+ languages including JavaScript, TypeScript, Python, Rust, Go, Java, Swift, HTML, CSS, JSON, Markdown, SQL, Shell, PHP, Ruby, C/C++, XML, YAML, and more. CSV and TSV files get a dedicated table viewer.
Files up to 50 MB can be imported. This is generous enough to handle large CSV/TSV datasets.
Yes. File edits are automatically saved to the database as you type.
Yes. Use the folder import button (📂) to import an entire directory. CodeDB will recursively import all supported files while preserving the folder structure.
Just open the file. CodeDB automatically renders CSV and TSV files as tables. Use the toolbar buttons to switch between Table, Raw, and Edit modes.
Yes. The CSV viewer uses virtual scrolling, so files with 100,000+ rows render smoothly. Only visible rows are added to the DOM at any time.
Not directly in the table. Switch to Edit mode, modify the raw text, and switch back to Table mode. The table will reflect your changes.
CodeDB uses SQLite. All standard SQLite SQL syntax is supported in the Query Console.
Yes. Query results can be exported as JSON, CSV, or Mermaid diagram syntax.
Contact us at codedb@mccanalytics.com or visit mccanalytics.com.