Clone this wiki locally
Frequently Asked Questions
What is sqlmap?
sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range of switches lasting from database fingerprinting, over data fetching from the database, to accessing the underlying file system and executing commands on the operating system via out-of-band connections.
How do I execute sqlmap?
If you are running on a UNIX/Linux system type the following command from a terminal:
python sqlmap.py -h
You can also see the detailed help message typing:
python sqlmap.py -hh
If you are running on a Windows system type the following command from a terminal:
C:\Python27\python.exe sqlmap.py -h
C:\Python27 is the path where you installed Python >= 2.6 and < 3.0.
Can I integrate sqlmap with a security tool I am developing?
Yes. sqlmap is released under the terms of the GPLv2, which means that any derivative work must be distributed without further restrictions on the rights granted by the General Public License itself.
Can I embed sqlmap into a proprietary software?
If you wish to embed sqlmap technology into proprietary software, we sell alternative licenses (contact email@example.com)
How can I report bugs or request new features?
- Before you submit a bug report, search both open and closed issues to make sure the issue has not come up before. Also, check the user's manual for anything relevant.
- Make sure you can reproduce the bug with the latest development version of sqlmap.
- Your report should give detailed instructions for how to reproduce the problem. If sqlmap raises an unhandled exception, the traceback is needed. Details of the unexpected behaviour are welcome too. A small test case (just a few lines) is ideal.
- If you are making an enhancement request, lay out the rationale for the feature you are requesting. Why would this feature be useful?
- If you are not sure whether something is a bug, or want to discuss a potential new feature before putting in an enhancement request, the mailing list is a good place to bring it up.
Can I contribute occasionally to the development?
All code contributions are greatly appreciated. First off, clone the Git repository, read the user's manual carefully, go through the code yourself and drop us an email if you are having a hard time grasping its structure and meaning. We apologize for not commenting the code enough - you could take a chance to read it through and improve it.
In order to maintain consistency and readability throughout the code, we ask that you adhere to the following instructions:
- Each patch should make one logical change.
- Wrap code to 76 columns when possible.
- Avoid tabbing, use four blank spaces instead.
- Before you put time into a non-trivial patch, it is worth discussing it on the mailing list or privately by email.
- Do not change style on numerous files in one single pull request, we can discuss about those before doing any major restyling, but be sure that personal preferences not having a strong support in PEP 8 will likely to be rejected.
- Make changes on less than five files per single pull request - there is rarely a good reason to have more than five files changed on one pull request, as this dramatically increases the review time required to land (commit) any of those pull requests.
- Style that is too different from main branch will be ''adapted'' by the developers side.
- Do not touch anything inside
By submitting code contributions to the sqlmap developers, to the mailing lists, or via Git pull request, checking them into the sqlmap source code repository, it is understood (unless you specify otherwise) that you are offering the sqlmap project the unlimited, non-exclusive right to reuse, modify, and relicense the code. sqlmap will always be available Open Source, but this is important because the inability to relicense code has caused devastating problems for other Free Software projects (such as KDE and NASM). If you wish to specify special license conditions of your contributions, just say so when you send them.
Can I actively contribute in the long-term development?
We are constantly seeking for people who can write some clean Python code, are up to do security research, know about web application security, database assessment and takeover, software refactoring and are motivated to join the development team.
If this sounds interesting to you, send us your pull requests - we are open to discuss granting of push access to the main repository if you prove professionalism, motivation and ability to write proper Python code.
How can I support the development and show my appreciation?
sqlmap is the result of numerous hours of passionated work from a small team of computer security enthusiasts. If you appreciated our work and you want to see sqlmap kept being developed, please consider making a donation to our efforts via PayPal to
How can I follow closely the development?
We tend to keep our Twitter page, @sqlmap, up to date with the development. We certainly update it more often than the mailing list. Hence, if you are keen on keeping a closer look at the development you can:
- Watch the project on GitHub given you have a GitHub account.
- Subscribe to the Atom feed in your feed reader of choice.
- Follow us on Twitter, @sqlmap.
- Watch demos on YouTube: #1 and #2.
- Subscribe to the mailing list.
Will you support other database management systems?
We already support the major and some minor databases. We do have plans to extend support for some of them and support also new ones: Informix and Ingres at some point in time.
Can you hack a site for me?
My site was attacked with sqlmap. Stop developing it you dumb f.cks!?
We get occasional rage bursts from unknown people. It should be emphasized that with each sqlmap run end users are obligated with the following prelude message:
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program
When sqlmap will switch to Python 3?
Currently there is no pressure on Python projects to switch to the new version of Python interpreter, as the process of switching, especially on larger projects can be cumbersome (due to the few backward incompatibilities). The switch will take place eventually, but currently it is a very low priority task.
How can I shorten the payloads injected by sqlmap?
You can provide sqlmap with the following switch:
--no-cast Turn off payload casting mechanism
However, on the other hand you might lose the benefits provided by this switch in the default configuration.
WARNING unknown charset '...' mean?
sqlmap needs to properly decode page content to be able to properly detect and deal with internationalized characters. In some cases web developers are doing mistakes when declaring used web page charset (e.g.
iso_8859 instead of standardized name
iso-8859), which can cause problems. As a failsafe mechanism we have incorporated heuristic detection engine chardet, so in most cases sqlmap will deal with this kind of problems automatically.
Nevertheless, you are strongly advised to report us back those typographic mistakes so we could handle them manually inside the code.
How to use sqlmap with
Append an asterisk,
*, to the place where sqlmap should check for injections in URI itself. For example,
./sqlmap.py -u "http://target.tld/id1/1*/id2/2", sqlmap will inject its payloads at that place marked with
This feature also applies to POST data. Multiple injection points are supported and will be assessed sequentially.
Why is sqlmap not able to get password hashes in some cases?
The session user most probably does not have enough permissions for querying on a system table containing password hashes.
What does switch
I am getting
[CRITICAL] connection timed while I am able to browse the site normally?
There are few IDSes that filter out all sqlmap requests based on its default
User-Agent HTTP header (e.g.
User-agent: sqlmap/1.0-dev). To prevent this
kind of situations you are advised to use switch
If you are getting those kind of messages for all targets then you most probably need to properly set up your proxy settings (switches
Is it possible to use
INSERT/UPDATE SQL commands via
It is possible to run those statements as well as any other statement on the target database given that stacked queries SQL injection is supported by the vulnerable application or you are connecting directly to the database with
-d switch and the session user has such privileges (or a privilege escalation vector has been injected upfront).
sqlmap is not able to detect/exploit injection while other commercial tools are?
In most of those kind of cases blatant error message detection is used by commercial tools leading to false positive claims. You have to be aware that a DBMS error message does not mean that the affected web application is vulnerable to SQL injection attacks. sqlmap goes several steps further and never claims an injection point without making through tests if it can be exploited on the first place.
How can I dump only certain entries of a table based on my condition?
sqlmap is very granular in terms of dumping entries from a table. The relevant switches are:
--dump Dump DBMS database table entries -D DB DBMS database to enumerate -T TBL DBMS database table to enumerate -C COL DBMS database table column to enumerate --start=LIMITSTART First query output entry to retrieve --stop=LIMITSTOP Last query output entry to retrieve --first=FIRSTCHAR First query output word character to retrieve --last=LASTCHAR Last query output word character to retrieve
However, in some cases you might want to dump all entries given a custom
WHERE condition. For such cases, we recommend using one of the following switches:
--sql-query=QUERY SQL statement to be executed --sql-shell Prompt for an interactive SQL shell --sql-file=SQLFILE Execute SQL statements from given file(s)
--sql-query "SELECT user, password FROM users WHERE privilege='admin'"
Where can I find old versions of sqlmap?
From the Tags page on GitHub.