SQuirreL SQL Client ou Oracle SQL Developer : une bonne alternative sous Linux ?

SQuirreL SQL Client, alternative Linux à Oracle SQL Developer

Mis à jour le 22 octobre 2026

Notre avis

SQuirreL SQL Client can replace Oracle SQL Developer for many day‑to‑day tasks such as connecting to Oracle databases, running queries, browsing schemas, and exporting results. It works on Linux, is free, and supports Oracle via the JDBC driver. However, it lacks Oracle‑specific features like PL/SQL debugging, migration wizards, and tight integration with Oracle Enterprise Manager. It is best suited for developers who need a lightweight, multi‑database client and are willing to use external tools for advanced Oracle tasks.

Couverture fonctionnelle70%

Licence: LGPL-2.1-or-later
Prix: Gratuit
Dernière version: 4.8.0 (1 septembre 2024)
Note: —

Installer SQuirreL SQL Client Site officiel ↗

The SQuirreL desktop in Ocean Theme

Ce qui fonctionne pareil

Both are Java‑based, cross‑platform IDEs for database development
Both provide a schema browser and SQL editor with syntax highlighting
Both support connection profiles and multiple database types via JDBC
Both allow exporting query results to CSV or Excel
Both have plugin or extension mechanisms

Ce qui change

SQuirreL lacks Oracle‑specific debugging and migration wizards present in SQL Developer
Oracle SQL Developer integrates with Oracle Enterprise Manager and AWR reports; SQuirreL does not
SQL Developer offers built‑in PL/SQL code completion and debugging; SQuirreL only offers basic editor features
SQL Developer can generate migration scripts for other RDBMS; SQuirreL has no such feature
SQL Developer is tailored for Oracle; SQuirreL is generic and may require manual driver configuration for Oracle

Ouvrir vos fichiers Oracle SQL Developer

SQuirreL SQL Client does not read Oracle SQL Developer project files (.xml, .sqd) or export directly to them. To move scripts, copy the SQL text manually or export results to a common format like CSV and re‑import. There is no built‑in conversion tool.

Passer de Oracle SQL Developer à SQuirreL SQL Client, étape par étape

Install the Oracle JDBC driver (ojdbc8.jar) and place it in SQuirreL’s driver directory or add it via the driver manager.
Create a new connection profile in SQuirreL: set the JDBC URL to jdbc:oracle:thin:@host:port:sid or service name, and enter your credentials.
Test the connection to confirm driver and network settings are correct.
Open your existing SQL scripts from Oracle SQL Developer and paste them into SQuirreL’s SQL editor, or use the File → Import feature if available.
Adjust any PL/SQL specific syntax if necessary, as SQuirreL’s editor may not highlight Oracle extensions fully.
Save the connection profile for future use and start running queries.

Fonctionnalités clés de SQuirreL SQL Client

Prend en charge des dizaines de pilotes JDBC dès l'installation
Explorateur de schémas avec arborescence des tables, vues et procédures
Éditeur SQL avec coloration syntaxique et historique
Visionneuse de jeux de résultats avec export vers CSV/Excel
Architecture de plugins pour les extensions
Interface utilisateur Java Swing multiplateforme
Capacité d'exécuter des scripts et des commandes par lots
Gestionnaire de connexions intégré avec profils enregistrés

Installer SQuirreL SQL Client sous Linux

Flatpak (Flathub)flatpak install flathub net.sourceforge.squirrel_sql

Questions fréquentes

Does SQuirreL support PL/SQL debugging?

No, SQuirreL does not provide a PL/SQL debugger. You would need a separate tool for that.

Can I use SQuirreL to migrate an Oracle schema to another database?

SQuirreL does not include migration wizards. You can export tables and data, but schema migration must be handled manually or with other utilities.

Is a Java runtime required for SQuirreL on Linux?

Yes, SQuirreL is a Java Swing application; it requires a Java Runtime Environment (JRE) or Java Development Kit (JDK) to run.

Notez SQuirreL SQL Client

Soyez le premier à noter

Bon remplaçant de Oracle SQL Developer ? 9