Public

🚀 DBCode - Data-Accompanied Code

DBCode is designed for developers who prefer shipping code over fumbling through tab switching. It offers a comprehensive suite of tools for database management, data exploration, and SQL development.

Documentation | Roadmap | Changelog | Discord Community

🚀 Quick Start

DBCode is a powerful tool for developers working with databases. It supports over 20 databases and offers a wide range of features to enhance the database development experience.

✨ Features

Database Support

Connect to over 20 databases, including:

• SQL Databases: MySQL, PostgreSQL, SQL Server, Oracle, SQLite, MariaDB, CockroachDB, DuckDB, StarRocks
• NoSQL: MongoDB, Redis, Cassandra
• Cloud Services: AWS RDS, Azure SQL, Cloudflare D1, SingleStore, MotherDuck, Timescale
• Big Data: BigQuery, Snowflake, Redshift

For more database support, refer to here.

Data Viewing and Editing

• Data Grid: An Excel-like interactive table supporting sorting, filtering, and grouping.
• Foreign Key Navigation: Click on foreign keys to quickly jump to related tables.
• Lineage Analysis: Visualize data dependencies.
• Result Charts: Convert query results directly into charts and graphs.
• Pagination: Efficiently handle large datasets.

Copilot Integration

• Intelligent Completion: Automatically suggest code snippets based on context.
• Auto Generation: Generate SQL queries from natural language descriptions.
• Interpretability: Show the basis and reasons for recommendations.
• Error Fixing: Actively detect and fix syntax issues.
• Performance Optimization: Provide various optimization suggestions to improve query efficiency.

Entity Relationship Diagram

• Automatic Chart Generation: Automatically generate ER diagrams based on existing data.
• Interactive Editing: Drag and adjust relationships directly in the diagram.
• Attribute Management: Display detailed attribute information for each entity.
• Constraint Checking: Highlight foreign keys and other constraints.
• Database Comparison: Compare differences between different schemas.

Data Exploration

• Fuzzy Search: Quickly find any table or column.
• Lineage Analysis: Visualize data dependencies.
• Quick Query: Save frequently used queries and execute them with one click.
• Parameter Setting: Specify different input parameters for queries.
• Multi-Result Set Management: View multiple query results simultaneously.

Custom SQL

• Syntax Highlighting: Support code coloring for multiple languages.
• Formatting Tool: Beautify complex queries to improve readability.
• Execution Plan: Show the execution plan generated by the optimizer.
• Result Caching: Automatically load the cache when running the same query repeatedly.
• DDL Editing: Directly modify table structures and other database definitions.

Inline SQL Help

• Context Completion: Provide relevant suggestions based on the current environment.
• Syntax Checking: Detect potential errors in real-time.
• Performance Analysis: Provide optimization suggestions and execution statistics.
• Result Preview: View partial results directly in the editor.
• Debugging Support: Support breakpoints and other debugging features.

Security Report Sharing

• Encrypted Transmission: Use SSL to ensure data security.
• Access Control: Set fine-grained permission policies.
• Audit Log: Record all user operations.
• Watermarking: Add custom marks to the results.
• Anonymization: Mask sensitive information.

Notebooks

• Code Snippet Management: Save frequently used code blocks for reuse.
• Version Control: Track every modification and support rollback.
• Sharing and Collaboration: Share notebook content with team members.
• Export as Document: Generate static pages from notes.
• Automated Execution: Schedule key tasks to run at specific times.

Stored Procedures and Functions

• Graphical Interface: Design stored procedures visually.
• Debugging Tools: Support breakpoints and logging.
• Test Cases: Automatically generate unit test frameworks.
• Version Control: Track every modification and support rollback.
• Dependency Management: Display all related objects.

Data Analysis Visualization

• Multiple Chart Types: Including bar charts, line charts, pie charts, etc.
• Interactive Filtering: Select data ranges directly in the charts.
• Drill-Down Function: Explore specific data points in depth.
• Dashboards: Create custom dashboards to integrate multiple charts.
• Data Stories: Tell the story behind the data through visualization.

Additional Features

• Import and Export: Easily migrate data from CSV or other databases.
• Multi-Database Sessions: Connect and query different databases simultaneously.
• Query Parameters: Reuse queries with different inputs.
• Custom Colors: Assign unique theme colors to each connection.
• Result Pinning: Save important query results for easy viewing.
• Automatic SSL Configuration: Simplify secure connection settings.
• Logging: Record all user activities and query history.

Pricing Strategy

Offer flexible pricing plans, including free trials, pay-as-you-go, and enterprise subscriptions.

Technical Support

Get 24/7 online support to solve any usage issues. Visit the official website for more detailed information.