Salesforce SOQL Query Runner VSCode Extension
A powerful VSCode extension for Salesforce developers that provides seamless integration with Salesforce orgs directly from your editor. This extension allows you to manage multiple Salesforce environments, explore object metadata, and execute SOQL queries with ease.
Preview Mode: This extension is currently in preview and actively under development. While core features are stable, we're continuously adding new capabilities to enhance your Salesforce development experience.
Features
Current Features
Coming Soon
Object Explorer
- Browse Salesforce objects and their metadata
- View field definitions and relationships
- Explore object permissions and sharing rules
- Quick access to object documentation
Data Export
- Export query results to CSV format
- Customizable export options
- Batch processing for large datasets
Additional Features
- Apex code execution
- Deployment management
- Custom metadata type explorer
- Schema comparison between environments
- Query builder with visual interface
Installation
- Clone this repository
- Run
npm install
to install dependencies
- Press F5 to start debugging or package the extension using
vsce package
Usage
- Click the Salesforce icon in the activity bar to open the environments panel
- Click the "+" button to add a new environment
- Fill in the environment details:
- Environment name (e.g., "Production", "Sandbox", "Dev")
- Login URL (e.g., "https://login.salesforce.com" for production)
- Username and password
- Right-click on an environment to:
- Set it as active
- Remove it
- Use the "Run SOQL Query" command to execute queries against the active environment
Example Queries
SELECT Id, Name FROM Account LIMIT 10
SELECT Id, FirstName, LastName FROM Contact WHERE LastName LIKE 'A%'
SELECT Id, Name, Industry FROM Account WHERE Industry = 'Technology'
Security Note
This extension stores your credentials securely in VSCode's global state. Credentials are only stored locally and are not transmitted to any external servers. The extension automatically handles connection management and provides visual indicators for stale connections.
Requirements
- VSCode 1.85.0 or higher
- Node.js and npm installed
- Salesforce account with API access
Changelog
v0.0.1 (Preview Release)
- Added support for multiple Salesforce environments
- Implemented secure credential storage
- Added visual environment management in side panel
- Added connection status tracking
- Added automatic connection refresh
- Added warning indicators for stale connections
- Added support for custom login URLs (for sandboxes)
- Added modern webview forms for environment management
- Added query results display in formatted table
Contributing
We welcome contributions! Please feel free to submit a Pull Request. As this is a preview release, we're particularly interested in feedback and suggestions for new features.
License
This extension is licensed under the MIT License - see the LICENSE file for details.
Roadmap
We're actively developing this extension with a focus on:
- Object metadata exploration
- Data export capabilities
- Enhanced query building experience
- Schema comparison tools
- Deployment management features
Stay tuned for updates as we continue to enhance the extension with new features and improvements.