> For the complete documentation index, see [llms.txt](https://docs-jmapserver-lima.k2geospatial.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs-jmapserver-lima.k2geospatial.com/e/administrator/jmap-server-administrator-manual/tools/sql-console.md).

# SQL Console

JMap Admin provides a generic SQL console that can be used to view database structures, execute SQL queries, inspect the content of tables, test for query execution speed, etc. 

{% hint style="info" %}
All configured databases are accessible through this console.
{% endhint %}

When performing an SQL query, the query execution is subject to security permissions granted to the user connected to the database. See [Creating Databases](/e/administrator/jmap-server-administrator-manual/resources-databases/creating-databases.md) section for more information about specifying the user for database connections.

<table data-header-hidden><thead><tr><th width="174"></th><th></th></tr></thead><tbody><tr><td><strong>SQL console</strong></td><td> </td></tr><tr><td>Database</td><td>Select the database to use.</td></tr><tr><td>View structure</td><td>Click on <img src="/files/Ebq0Hv4efuC5EwCDHZPY" alt=""> to open a window that allows you to navigate in the structure of the database. <br>You can see the schemas, the tables and views, and information about each field of a table or view.</td></tr><tr><td>Max. rows</td><td>When executing a SELECT SQL query, you can enter a value to limit the number of returned rows.</td></tr><tr><td>Auto commit</td><td>If performing SQL transactions (e.g. INSERT, UPDATE), select this option to validate the transactions automatically (SQL COMMIT command). Otherwise, you will need to perform the validations manually.</td></tr><tr><td>Test for speed only</td><td>When executing an SQL query, select this option to repeat the query a certain number of times and display the execution times.</td></tr><tr><td>SQL Query</td><td>Enter the SQL query to execute. The result will be displayed in a table.</td></tr></tbody></table>

Query results are displayed in a new window. The results of the INSERT, UPDATE, and DELETE requests are grouped in the same tab. The results of SELECT type queries appear in separate tabs.