mtxr/
Database management for VSCode
USD raised
Recent activities
Add option to ask for username
display error number and SQLSTATE along with server response text for MySQL (and other servers?..)
region folding broken
Doesn't work with mysql9
cannot display the path
Add a cli/binary for the formatter
When creating a user in Redshift with 'sha256 hash' encrypted password and salt, the SQL tools cannot connect
Help to configure SQLtools multiple queries
Open database from link
Add setting to automatically open results as csv/json
Error when using assigned shortcut to open or save results
Issue
Cant connect to planetscale DB
Unable to View Tables in Redshift Database - "Relation Does Not Exist" Error
Getting "command 'sqltools.executeQuery' not found" error when trying to run a query
Connect to Dremio Cloud
SQLite driver with custome node runtime not using globally installed sqlite3 package
Add "Functions" Folder to Schema in VSCode SQLTools Extension for Easier Access to Stored Procedures
Reports Errors from Goose MIgration Scripts
Stripping the batch separator 'GO'
Foreign Key Constraints Enforced or Not? SQLite with SQL Tools
Extension 'mtxr.sqltools' FAILED to handle event: TypeError: Cannot read properties of undefined (reading 'document')
Intellisense does not trigger when using multi-line SQL statements.
Datetime Fields Appear as Epoch when Exported from Visual Studio Code
Display query statement within query result view
Result Tab - Duplicating keyboard shortcut commands
View results table in rotated/transposed/vertical layout (rows become columns)
issues to do clone
Setting connections with environment variables
Increase SQLite Version
[PostgreSQL] Render utf8 encoded text in `bytea` columns
Attempting to run individual statements or clicking '🔒 Active Connection' results in error messages despite existing connection.
"Select File" use native vscode file selector
Filters being saved across separate queries causing unexpected missing results
Option for leading commas
Reading records fails
New keybinding command
mariadb versioned tables not displayed
json server installation problem i didn't install now
Newlines before comments are sometimes removed
Intellisense for db.schema.table table source
Add support for Denodo Data Virtualization Driver
Support more keywords (Postgres)
SQLITE_MISUSE error only when using "run on active connection" because of comments
ERD diagram
extension cant show
when i enter the password for connecting mysql and when i click test connection nothing is happening
ERROR (ls): TypeError [ERR_INVALID_ARG_TYPE]
error
Connection
AWS RDS connection via SSM and SecretsManager
Firebird Driver
Getting error detecting node runtime
Connect to a MSSQL server in a different AD domain than the one that the Macbook user is authenticated through and with a different user name
Make SSL Requirements Optional
Multiple Valid SQL Statements, Valid SQL Statement Termination - Parse Error
Display execution time after running a query
Results table names all additional unnamed columns "?column? (1)" and conflates their output
Results Limit Setting Doesn't Seem to Work
Causing unnecessary highlighting of text even when nothing is selected
Add new setting to let us specify what shows up in the results pane tab header
Add Setting to Hide Results Pane Status Bar
Leading Spaces Are Trimmed in Results Pane
Formatter breaks procedure/function code
Formatting breaks postgres commands (e.g. \echo)
query output returns no data
should match format "data-url" ?
Allow to specify session file location relative to workspace root
Searching Paginated Data
Support for multi-database connections
Querying temporary table in same query it was created yields no results
can't use vscode-sqltools
Datatype on postgres not shown
Provide alternative data viewer setting and API to use for displaying SQL query results
When is the next release planned? What is the release cycle?
work on only one database
Support authentication via Azure Active Directory - Universal with MFA
cannot connect to database SQLTools Version 0.28.0, MSSQL/Azure, Windows
New proposals
"Can't execute query. You have selected nothing" on VS Code Linux
Is it possible to get this for Elixir ?
Is is possible to get this for Elixir ?
Submit SQL Tools extension to be added to the Azure Data Studio extensions gallery
Formatting issues with postgres: format(...), public.* + table_name.*
Odd formatting for ALTER TABLE statements
Empty comment at end of file gets mis-formatted
Run the line with cursor on (accessibility)
Wrap columns containing spaces in backticks
What's the best way to implement dry run?
Node runtime detection fails when `oh-my-zsh` update is available
Sort arrow on export sorts by digits, not value
Raw export choice
[Feature] Execute markdown snipped
Option to format SQL with commas after line feed instead of before.
'Open Editor with Cell Value' does not work for JSONB columns
Error when creating trigger
Remove testing pin to 1.77.3 when VS Code issue is resolved
Get ERROR for azure-active-directory-password in mssql
Result Location Direction Setting
Clicking "disconnect" resulted in the database not closing and instead reconnecting.
Display nullability of table columns
SQL repl
sql formatter adds spaces to regex expressions which damages queries
Execution query from another Extension
Executing query when using SQLTools inside Jupyter Notebook
Windows Authentication
Connect to multiple databases in postgresql
how to connect different connections at same time
Add a preferences option to set a static/dynamic directory to save the sessions into
Export and Open buttons not working with SAP HANA driver
Sqltools setting tab is coming blank
Postgres server displays nothing in the connection explorer when expanded
Schema and tables not showing up for SQL server hosted on ubuntu server
[Feature] Delete a record or all record without an SQL query?
Warn if Node version is too low
Autofill name and group when bookmarking
Add drag and drop of explorer objects into editor
Add Format Support for TSQL
the SQLTools language server crashed, SyntaxError: Unexpected token
Bug: Launching server using runtime node failed.
SQLTools Formatter doesn't work in Safari
Export directly to a file
mssql: Error 40532: Cannot open server "xxx.com" requested by the login. The login failed.
Queries with Larger result tables break postgres driver connection
Settings in development container
Table Completions not returning all tables
Attempts of SQLTools to install npm and node cause trouble
Sql snippets ,autocomplete and run on active connection not working after saving
SQL Server for PostgreSQL
Stop formatter from adding spaces inside braces.
Improve sharing of variables
Unnecessary notifications on every VS Code boot
Bookmark rendering glitches
Hi, Can hover be supported
ER_NOT_SUPPORTED_AUTH_MODE when using MySQL driver
Extension causes high cpu load
multi-cursor selections are not executed as expected
SQLITE_MISUSE on comments after command in the same line
Ability to create a connection without database name (cross-database query)
Formatting should follow the SQL Style Guide
Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'
When columns change and the results tab is reused, an error is shown
showing DETAIL of sql error message
executing create plpgsql function runs properly only if selecting the all function definition lines
Symbols for vscode outline view?
Unable to change default schema in database connection
SQL version control
Intellisense fetches information about all databases in the cluster to show in autocomplete
Global Connections
Show results in console
Refresh button does not work when creating a Database
Postgres EXPLAIN ANALYZE result view as text
`DEFAULT` is not colorized as keyword
Completions for table names in PostgreSQL is not fully correct
Node runtime detection fails with PowerShell 7 on macOS and maybe Linux too
Modal warning about 'detect node runtime' is too eager
Error fetching records. ER_BAD_DB_ERROR: Unknown database 'xyz'
Image (icon) of AWS Redshift is missing in VSCode description
Separator lines between the columns and rows
Merge connection configurations across setting scopes
Support `${workspaceFolder}` variable in sqltools.sessionFilesFolder setting
Can't connect to user
Cannot input table in command palette "Show Table Records"
Add New Connection does nothing
0.25.0 release record needs finalizing and 0.25.1 record needs adding
Add a badge to the Activity Bar icon showing how many connections are connected
Driver icons in connection tree are hard to see in dark themes
Most of VSCode hangs when a large sql file is open
`Copy value(s)` context menu command in SQL Console doesn't work
Running multiple queries at once
None of the buttons do something and an error with detecting node runtime
Can i get json results when query finished for default open ?
Reduce how many times the Node runtime auto-detected notification is displayed
Does the extension provide linting functionalities
‘DELETE’ does not have an automatic prompt，but ‘CREATE’，‘INSERT’... has
Databricks support
Enable CodeLens integration only for *.session.sql files / Command to enable on demand for other files
[BUG] preserve empty line between SQL blocks
Any server address returns "Successfully connected!"
Open query results in bottom split panel
Having trouble executing Query
Connect to postgres using pg_service ?
Cannot activate the 'SQLTools MySQL/MariaDB' extension because it depends on the 'SQLTools' extension, which is not installed. Would you like to install the extension and reload the window?
Weird formatting when queries contain `create` - or possibly caused by WSL?
Show row numbers in results grid
Foreign Key query results clicable
Add a config option to suppress "Insert" SQL Console Messages
Improved titles/custom result titles
Trusted Connection = Yes prompts for password
404 on docs
dictGet support for clickhouse code formatter
Consider activating this extension only for specific events
Show Postgresql foreign tables
Output tab doesn't return BLANK value
Unable to see connection tree
Stored Procedures for MySQL and MSSQL
Bigquery Support
User level "settings.json" is ignore if a local ".vsocde/settings.json" sqltools.connections block exists
User level "settings.json" is ignore if a local ".vscode/settings.json" sqltools.connections block exists
How to volunteer to fix your tutorials, documentation, UI, installation, basically the entire thing?
Test Connection Success with wrong credentials
Make SQL Tools settings recognise VS Code variables and environment variables.
command 'mssql.runQuery' not found
The documentation page is missing???
Full error message display from database server
Add option "use windows authentication" in connection Assistant for SQL Server
Connection lost on SQL Server
Add "drop table" option
All connections gone, cannot add new conenction.
connections fails / maybe TLS version problem
Do not format with fewer fields
Format even short queries
Unable to save results as CSV or JSON. EXPORT, Open Results and Save Results all broken.
The formatter doesn't handle some blocks correctly
Invalid regular expression
Choosing the database driver if you are blind
Formatter should respect indentation
A format option for bracket
Formatter breaks postgres @@ syntax
Format-on-save for UNION statements continues to indent first line
not able to connect AWS postregSQL database
SQLTools Ability to Connect to Dev Containers?
Double Click Field name to add at cursor
Allow to see the `create table` sql
Oracle Driver porting or adding
Ability to run a bookmark query across multiple selected database connections
Add default bookmarks or use project depending storage
vscode navigation hot-keys stop working on query results panel
Character "greater than" > breaks comments
Redshift connection using ODBC driver
Reuse one results window/tab for all queries
Formatter types path incorrect in latest @sqltools/formatter version
MySQL's NULL-safe equal is not correctly formatted
Not connecting with 'unix_socket' Mariadb plugin
Error Message on Database Connect: "Cannot read property 'localeCompare' of undefined"
Unable to install sqlite3 npm package
Improve autocomplete
Ability to open "source" for Postgres function
publishing sqltools in Open VSX Registry "managed by Eclipse Foundation"
Database object names should maintiain case sensitivity
ERROR: Error opening connection Hostname/IP does not match certificate's
Wrong format of COPY FROM syntax of postgresql
Add interpolated variables
format.linesBetweenQueries "preserve" is not working?
Add localization options for CSV export
Using VS Code Variables In Settings
SQLite - nested REPLACE statements cause freeze
Correct way to import sqlFormatter from @sqltools/formatter?
MSSQL Driver - Request to add Additional TDS Connection Parameters On UI
Output SQL results as Markdown and text
Support for functions/procedures
Cant use null at the "Database" property
Table Designer for create / alter table
Show syntax error in Problems instead of SQL Console: Messages
Ctrl+E conflicts with vscode "Go to File"
Not all rows exported
A column created by "COUNT(*)" uses string comparison instead of int comparison in result page
MSSQL connection shows other databases at top level.
ADD A SYBASE DRIVER FOR CONNECTION
MS SQL driver: I can get connection to a DB and run SQL but I cannot see list of tables
Ideas for SQL Tools in MySQL
Connection Error when DB uses Windows-Authentication
UPDATE queries have no table or field autocompletion
improved Bookmark functionality
Add targeted deletion to history buffer
Display query detailed info
Add the extension to open-vsx.org
[PostgreSQL] - SSL without validating certs
Pagination is not working on query results
Error while showing table records Cannot read property 'total' of undefined
add compatibility with Remote Development
Can you publish the `QueryParser` to npm?
request for connection keep-alive setting
Implement basic accessibility features (keyboard navigation) for the Results pane
Remove duplicates from table columns
Support to run multiple files
Allow database field to be empty in Connection Assistant.
:bug: Split space formatter creates invalid syntax for Postgres escaped string literals `E'This is a comment'` erroneously corrects to `E 'This is a comment'`` which is no longer parseable
Where can I download 0.21.9 vsix, I cannot find it
requiring self-signed cert when rejectCert is set to false
Show binary fields as hex
Passwordless Login for PostgreSQL using `peer` authentication method
Using incorrect database
Formatter stops working on VS code restart
Ability to clone a row
Add some options in configuration for sql formatter
"self signed certificate" issue when creating new DB connections
Show result in Vertical - Like \G in mysql prompt
Intellisense in javascript files via template literals
Missing option to store connection info in userspace
Formatter: don't wrap queries if short
Possible to only display the final output of statement blocks?
"Select file" for socket file path looks locally even in a remote workspace
[Formatter] Configurable option for inline statement length.
optimize the result header of the query
Exploring a different database in the connection explorer with the same schema shows incorrect data
Driver not found but installed
Next release
Possibility to connect to db without specifying database
Delete connection and recreate identical one keep previous connection databases
Crash vscode when using sqltools (1)
Cannot connect to Oracledb
Couldn't start client SQLTools Language Server
Trying to connect to Cassandra get error "Cannot read property 'results' of undefined"
Could you support MongoDB?
Add "Run Query" button to the Editor Groups bar for SQL files
Accepting DELIMITER syntax on MySQL and MariaDB
As option to save results as Insert statement
Return DBMS Output message while executing procedure in Oracle
Toggle case sensitive sorting in result pane
Add possibility to view indices, foreign keys etc.
Keep chosen DB while connecting to multiple DB during autostart
Use pgpass file
Linux sqlite, strange behavior
Unexpected behaviour for commands which make session-level changes
Query progress indicator eats CPU
Connect to azure mysql - ssl - get error UNKNOWN_CODE_PLEASE_REPORT: SSL connection is required. Please specify SSL options and retry.
Does this plugin support ddl export？
the proxy function is very useful
Encryption/hashing of credentials in settings
Add support for Postgres Transactions
Formatting testcase: results not as expected
Formatting support for Jinja templating
SSPI login to PostgreSQL times out/fails
store passwords in env vars
Add fuzzy search during connection selection
Support sql template literal in javascript?
how to edit connection json manually?
Publish Language Server part to npm repository
Ability to Customise the Results panel.
Support connections over SSH
Generate UPDATE query
Ability to add/modify objects (Databases, Schemas, Tables, etc) graphically via sidebar option
SQLIte integration: How to Load a SQLIte Extension on a per database basis?
Remember or auto attach connection to chosen files
Filter/select database(s) to list on explorer
Add/edit rows
Adjust the default position of the sql result tab.
Store connections somewhere else than settings
© 2019 BoostIO, Inc.
IssueHunt
