# 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. All configured databases are accessible through this console.

When performing an SQL query, the query execution is subject to security permissions granted to the user connected to the database. See [Creating Databases](/en2/administrator/jmap-server-administrator-manual/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/vJ5m0KN8qFpn2LDtXPaB" alt=""> to open a window that allows you to navigate in the structure of the database. 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.k2geospatial.com/en2/administrator/jmap-server-administrator-manual/databases/sql-console.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.