Stack Overflow
Stack Overflow

Questions tagged [squirrel-sql]

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Summary

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Website

  • Project Homepage
  • Download squirrel-sql-x.x.x-optional if you want all of the plugins installed.

Features

  • Supports autocomplete when creating queries by pressing CTRL+SPACE.
  • On-the-fly generation of ERD diagrams.

Useful Keyboard Shortcuts

  • CTRL+SPACE - autocomplete database, table, and fields in queries.
  • CTRL+t - SQL Editor Tools Popup
  • CTRL+j - Display Query Bookmarks
    (Note: need to enable with CTRL+t edit bookmarks first.)
  • CTRL+SHIFT+, / CTRL+SHIFT+. - switch to prev/next results tab

Useful Plugins

  • UnityJDBC - A plugin for SQuirreL that allows queries involving multiple kinds of databases, much in the same way that MS-Access allows linked tables.
290 questions
5
votes
1 answer

Create a new table in SQuirreL SQL through the GUI?

Is it possible to create a new table in SQuirreL SQL through the GUI? I can't seem to find a way to do it on the UI. This is one of the most basic piece of functionality that a db visual tool should have so I would be very surprised if you cannot do…
fulhamHead
  • 687
  • 1
  • 10
  • 23
5
votes
2 answers

How to Import a .csv file into MySQL using SQuirreL

I m using SQuirreL SQL and I want to import a .csv file into MySQL. Please tell how to do that.
kratika gupta
  • 91
  • 1
  • 1
  • 4
5
votes
2 answers

Cannot connect to MySQL db using SQuirreL

I have trouble connecting to MySQL using the client Squirrel SQL. I managed to connect to Oracle and Derby previously, but this time, I do not know what I am doing wrong. I have installed MySQL on my Mac, following these steps: To install…
lcazarre
  • 713
  • 3
  • 9
  • 15
5
votes
2 answers

SquirrelSQL render flickering in SQL view

Everything works great with SquirrelSQL except for a weird bug while using the SQL view. If I switch back to this view, type in it, click on it, or in any way interact with the SQL view, the window seems to re-render multiple times. It looks like…
SortingHat
  • 727
  • 3
  • 15
  • 30
5
votes
3 answers

On DB2 for i, Search for Column, return table names in list form

I'm still a bit of a noob, so pardon if this question is a bit obvious. I did search for an answer but either couldn't understand how the answers I found applied, or simply couldn't find an answer. I have a massive database housed on a DB2 for i…
Jay Carr
  • 1,195
  • 6
  • 16
  • 32
5
votes
1 answer

Is it possible to open more than one query tab without opening another connection via Alias in Squirrel SQL?

I keep commenting out my queries in the SquirreL SQL client, but I also have been opening new connections using other Aliases, however it all gets a bit crowded in the tab area. I've also been able to save my queries in files, which works great…
leeand00
  • 25,510
  • 39
  • 140
  • 297
5
votes
3 answers

How to define/declare and use variable in Squirrel SQL client 3

I use the software SQuirreL SQL Client Version 3.2.1 and I want to declare variable like define dateFrom = '13/04/2012'; define dateTo = '13/04/2012' And to use it in my sql query like that SELECT * FROM table_name WHERE TRUNC(column_name) BETWEEN…
BasicCoder
  • 1,661
  • 10
  • 27
  • 42
4
votes
1 answer

How to configure Squirrel SQL for SQL Server Windows authentication

I tried to connect Squirrel to MS SQL Server database which is based on Windows Authentication, not a regular username and password things. But it seems a bit tricky whit Windows Authentication. it would be great if someone put the step by step…
Kamyar Gilak
  • 1,044
  • 2
  • 17
  • 23
4
votes
2 answers

Squirrel-SQL throws class not found exception

I am running Squirrel-SQL version 3.9.0 using JDK 10 on MS-Windows 10. I have configured the Microsoft SQL server JDBC driver sqljdbc42.jar along with it's native DDLs to enable native kerberos authentication. But when I try to connect to my…
Rahul Khimasia
  • 473
  • 12
  • 24
4
votes
1 answer

Squirrel SQL Resonnect Session

In my Squirrel SQL, I've got a few session tabs, each with a number of open tabs for queries I have run in the past and corresponding query results. That is very handy should I want to "re-live the experience of firing a query" or quickly modify a…
Nestor Milyaev
  • 5,845
  • 2
  • 35
  • 51
4
votes
4 answers

PL/SQL on SquirreL SQL Client 3.7.1

I was trying to execute PL/SQL scripts on SQuirrel but it doesn't seem to work. I configured Oracle Thin Driver by adding ojdbc7.jar on "Extra Class Path", was able to connect to the database but when tried to run a simple code it gives an error: --…
Thiago Alves
  • 53
  • 1
  • 5
4
votes
4 answers

Connecting Squirrel Client to DB2 Server over SSL Connection

I am using Squirrel 3.5.0 client to connect to DB2 Database. Recently I have changed my DB2 to run on SSL instead of normal TCS/IP. Now I want Squirrel to connect to my DB2 server using SSL port. So I updated the port number in the connection…
Prerak Tiwari
  • 3,436
  • 4
  • 34
  • 64
4
votes
2 answers

Installing driver for Squirrel sql client on linux to connect to MS sql server

I am trying to connect to MS SQL server database from linux. I can connect with Microsoft SQL server management studio on windows to same. I am trying to use squirrel sql client. I am not sure about the driver I need to use and how to install it.
mrk m
  • 125
  • 1
  • 3
  • 15
4
votes
3 answers

Squirrel SQL & H2 plugin on Windows: ClassNotFoundException: org.h2.Driver

I am trying to use the Squirrel SQL client to connect to a H2 server instance. The problem I am facing is that when I hit the "connect" button of the server I want to connect to, then I am getting a: ClassNotFoundException: org.h2.Driver I thought…
Neoasimov
  • 1,111
  • 2
  • 10
  • 17
4
votes
2 answers

SQuirrel - Prevent multiple result tabs

I am using SQuirrel SQL Client Version 3.5 and everytime I modify and run a query it opens up a new result tab. I would prefer that it re-use the existing result tab (replacing the contents) Is there a way to do this?
Mike Cheel
  • 12,626
  • 10
  • 72
  • 101
1 2
3
…
19 20