VSCode plugin + guide

Custom VSCode Plugin for MySQL Database Management

Overview

This plugin is designed to enhance your development workflow by providing seamless connectivity and navigation capabilities for MySQL databases directly within Visual Studio Code. It allows users to connect to multiple databases, browse schemas, execute queries, and manage database objects efficiently without leaving the editor environment.

Features

• Database Connection Management: Easily connect, disconnect, and switch between multiple MySQL databases.
• Schema Navigation: Browse tables, views, stored procedures, and other database objects in an organized tree view.
• Query Execution: Run SQL queries directly from the editor with results displayed within VSCode.
• Object Management: View detailed information about database objects and perform basic management tasks.
• Secure Authentication: Supports username/password authentication and SSL connections for secure access.

Installation Guide

1. Open Visual Studio Code.
2. Navigate to the Extensions view by clicking on the Extensions icon or pressing Ctrl+Shift+X.
3. Search for “MySQL Navigator” (or the specific plugin name).
4. Click “Install” to add the plugin to your environment.
5. After installation, reload VSCode if prompted.

Usage Instructions

Connecting to a Database

1. Open the Command Palette (Ctrl+Shift+P).
2. Type “MySQL: Connect” and select it.
3. Enter your database connection details:
   • Hostname/IP address
   • Port number (default: 3306)
   • Username
   • Password
   • Database name (optional)
4. Save the connection profile for future use.

Navigating Databases

• Access the database explorer panel from the sidebar.
• Expand your connected profiles to view available schemas and objects.
• Click on any object (table, view, procedure) to view details or perform actions.

Running Queries

1. Open a new SQL file or select existing SQL code.
2. Use the command palette (Ctrl+Shift+P) and select “MySQL: Run Query”.
3. View results in the integrated output window.

Managing Objects

• Right-click on database objects within the explorer panel for options such as:
  • Viewing data
  • Exporting schemas
  • Dropping or renaming objects (where supported)

Best Practices

• Regularly update your plugin to benefit from new features and security patches.
• Use secure credentials management practices when saving connection profiles.
• Test queries in a development environment before executing on production databases.

Support & Feedback

For assistance or to provide feedback, please visit our GitHub repository or contact our support team through the plugin’s help menu.

---

This guide aims to facilitate an efficient workflow with your MySQL databases directly within Visual Studio Code, streamlining development tasks and improving productivity through integrated database management capabilities.

25.00€ – Purchase Checkout Added to cart