Find answers, get step-by-step guides, and learn how to make the most of SQLDeveloper for your database management needs.
Find what you need quickly with our organized help categories
New to SQLDeveloper? Start with our beginner-friendly guides and tutorials
Quick answers to the most common questions about SQLDeveloper
Solve common problems and get your database connections working
Comprehensive technical documentation for advanced users
Connect with other users and share your knowledge
Get help directly from our support team
Step-by-step tutorials to help you master SQLDeveloper
Learn how to download and install SQLDeveloper on Windows, macOS, or Linux with our comprehensive setup guide.
-- Test your installation with this simple query
SELECT 'SQLDeveloper is working!' AS message,
VERSION() as version,
NOW() as current_time;Master the art of database connections with support for MySQL, PostgreSQL, SQLite, and more.
-- Connection String Examples:
-- MySQL: mysql://user:password@localhost:3306/database
-- PostgreSQL: postgresql://user:password@localhost:5432/database
-- SQLite: sqlite:///path/to/database.dbStart with basic SELECT statements and progress to joins, aggregations, and complex queries.
-- Basic SELECT with filtering and sorting
SELECT name, email, created_at
FROM users
WHERE status = 'active'
AND created_at >= '2024-01-01'
ORDER BY created_at DESC
LIMIT 10;Learn to efficiently move data between SQLDeveloper and external formats like CSV, Excel, and JSON.
-- Import CSV data using LOAD DATA (MySQL)
LOAD DATA INFILE 'users.csv'
INTO TABLE users
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;Speed up your database queries with indexing, query planning, and performance best practices.
-- Analyze query performance with EXPLAIN
EXPLAIN SELECT u.name, p.title
FROM users u
JOIN posts p ON u.id = p.user_id
WHERE u.status = 'active'
AND p.created_at >= '2024-01-01';Implement proper security measures including user permissions, SSL connections, and data encryption.
-- Create a read-only user
CREATE USER 'readonly_user'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT ON database_name.* TO 'readonly_user'@'%';
FLUSH PRIVILEGES;Quick answers to common questions about SQLDeveloper
Connecting to your first database is simple:
Pro tip: Use SSH tunneling for secure connections to remote databases.
SQLDeveloper supports a wide range of database systems:
We're constantly adding support for additional database systems. Check our documentation for the most up-to-date list.
Yes! SQLDeveloper offers a comprehensive free version that includes:
We also offer a Pro version ($49/month) with additional features:
Both versions are free for educational institutions and open-source projects.
Absolutely! SQLDeveloper is free for both personal and commercial use. You can:
There are no restrictions on commercial use of the free version. The only limitations are on the Pro features, which require a license for commercial deployment.
For enterprise deployments with over 100 users, contact our sales team for volume licensing options.
Updating SQLDeveloper is easy and automatic:
Important notes:
Solve problems quickly with our troubleshooting guides
Cannot connect to database or connections keep timing out.
# Test connectivity commands
ping database-server.com
telnet database-server.com 3306
netstat -an | findstr 3306Queries are running slowly and affecting application performance.
5; -- Add indexes CREATE INDEX idx_users_email ON users(email);
SQLDeveloper is using too much memory or crashing.
2048m
Getting "Access denied" or authentication errors.
-- Reset MySQL user password
ALTER USER 'username'@'localhost' IDENTIFIED BY 'newpassword';
FLUSH PRIVILEGES;
-- Check user grants
SHOW GRANTS FOR 'username'@'localhost';Failed to export data or import files into database.
Unable to update SQLDeveloper to the latest version.
# Clear update cache (Windows)
del %APPDATA%\SQLDeveloper\update_cache\* /q
# Clear update cache (macOS/Linux)
rm -rf ~/.sqldeveloper/update_cache/*Can't find what you're looking for? Our support team is here to help you solve any issues.