README.md•5.48 kB
# DBCode - Data Beside Code
<p align="center">
<a href="https://dbcode.io/docs" target="_blank">DOCS</a> | <a href="https://dbcode.io/roadmap" target="_blank">ROADMAP</a> | <a href="https://dbcode.io/changelog" target="_blank">CHANGELOG</a> | <a href="https://discord.gg/FvAzEAHb9w" target="_blank">DISCORD</a>
</p>
For devs who'd rather ship than <strike>fumble</strike> alt-tab around.
## Database Support
Connect to 20+ databases including:
<img width="100%" alt="data-editor" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/logo_panel.png">
[See more](https://dbcode.io)
## Data Viewing & Editing
<img width="100%" alt="data-editor" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/videos/editing.gif">
<ul>
<li>⚡ Filter, Sort, and Group data with a few clicks</li>
<li>🔄 CRUD operations without writing SQL (I know, sometimes it feels like cheating)</li>
<li>✅ Changes verified before execution - because we all have that production horror story</li>
</ul>
## Copilot Integration
<img width="100%" alt="copilot" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/videos/copilot.gif">
<p>Query your data with natural language. Ask schema questions, generate queries, create tables - because sometimes typing "SELECT * FROM" for the 100th time is just too much effort.</p>
## Entity Relationship Diagrams
<img width="100%" alt="erd" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/videos/erd.gif">
<p>Auto-generated diagrams that map your database structure. Your DBA will think you spent hours on this.</p>
## Data Exploration
<img width="100%" alt="erd" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/videos/relationships.gif">
<p>Navigate foreign key relationships with a click. No JOINs required.</p>
## Custom SQL
<img width="100%" alt="custom SQL" src="https://github.com/dbcodeio/public/assets/1918994/650632b0-da26-4b98-9f66-5138a7db1e7e">
<p>Write and execute your own queries right within VS Code. For when you need to flex those SQL muscles.</p>
## Inline SQL Help
<img width="100%" alt="signature" src="https://github.com/dbcodeio/public/assets/1918994/1efd912b-7750-47d0-a2e9-7aaaff0b0c52">
<ul>
<li>🔍 Database-specific SQL keywords - no more forgetting dialect differences</li>
<li>📊 Table/view/procedure intellisense with data types - because remembering every column name is for computers</li>
</ul>
## Secure Report Sharing
<img height="300" alt="share" src="https://raw.githubusercontent.com/dbcodeio/public/main/public/share.png">
<p>Share reports securely with encryption - no credentials or data exposed. Your security team will finally stop giving you that look.</p>
## Notebooks
<img width="100%" alt="notebook" src="https://github.com/dbcodeio/public/assets/1918994/6295585e-f13f-46b7-98e1-80e850485db1">
<p>Use VS Code Notebooks for database work. Query, analyze, and document in one place.</p>
## Stored Procedures and Functions
<img width="100%" alt="stored-procedure" src="https://github.com/dbcodeio/public/assets/1918994/dae92d32-13b7-4f90-8bcb-67116a5468cd">
<p>Edit database logic in your favorite code editor. Say goodbye to those prehistoric database IDEs.</p>
## Data Visualization
<img width="100%" alt="chart" src="https://github.com/dbcodeio/public/assets/1918994/d1d33ee9-9b3b-408f-9477-f208cf2adf87">
<p>Transform query results into charts and graphs. Impress stakeholders with minimal effort (I won't tell).</p>
## Additional Features
- **Import**: Easily import data from CSV files or other database tables
- **Export**: Get your data out when you need it elsewhere
- **Multi-DB Sessions**: Query across databases simultaneously
- **Query Parameters**: Reuse queries with different inputs (less copy-paste, more productivity)
- **Custom Colors**: Color-code your connections - production remains red, naturally
- **Result Pinning**: Keep important query results around
- **SSL Auto Config**: Automatic SSL setup for [known hosts](https://dbcode.io/docs/connections/auto-ssl)
- **SSH Tunnels**: Manual config or auto-discovery from SSH config
- **Theme Support**: Full compatibility with VS Code themes
- **Localization**: Available in all VS Code supported languages
- **Fuzzy Table Search**: Find that table even when you can't remember its exact name
- **Quick Query History**: Revisit recent queries without retyping - perfect for iterative development
- **Command Palette Integration**: All database actions at your fingertips, keyboard warriors rejoice
- **[More Features](https://dbcode.io/features/)**
## Pricing
Core features are free, forever. Some advanced features require a subscription. See our [Pricing](https://dbcode.io/pricing) page.
## Contributors
- [Pradeep Kumar](https://www.linkedin.com/in/pradeep-kumar-1722b6123/): Documentation, Testing
- [Lanterns](https://github.com/L4nterns): Translation
- [snickerjp](https://github.com/snickerjp): Translation
- [intervisionlord](https://github.com/intervisionlord): Translation
A heartfelt thank you to these incredible contributors who have generously donated their time and expertise. DBCode wouldn't be the same without their input.
## Telemetry
We collect anonymous usage data when VS Code telemetry is enabled. This helps us improve the extension.
Telemetry respects your VS Code settings - if disabled there, we collect nothing. See our [privacy policy](https://dbcode.io/legal/privacy-policy/).