robotframework-databaselibrary
Database Library for Robot Framework
Decision gist · record as of 2026-08-14
Yes, if you are using Robot Framework for test automation and need to query or verify databases. Install friction is low and the library is permissively licensed. Maintenance is aging (last release 213 days ago), so verify that your target database driver is supported before committing; no known vulnerabilities are present. Suitable for teams already invested in Robot Framework who want database testing without custom code.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires a separate Python database module (e.g., oracledb, pymysql, psycopg2) to be installed separately depending on your target database.
- Low install friction with a pure-wheel distribution.
- Maintenance status is aging—last release was 213 days ago—but the repository remains active and has not been archived.
License · maintenance · safety
Apache License 2.0 (permissive) — Licensed under Apache License 2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions.
last release 2026-01-13 (213 days) · last repo commit 2026-01-13 · 178 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 392,715 downloads/mo, #7,006 on PyPI
Alternatives
Verify before relying
pip install robotframework-databaselibrary
*** Settings ***
Library DatabaseLibrary
*** Test Cases ***
Query Database
Connect To Database oracledb db_name=db db_user=user db_password=pass db_host=127.0.0.1 db_port=1521
${rows}= Query select FIRST_NAME from person
Should Be Equal ${rows}[0][0] Franz Allan- Whether the library actively maintains compatibility with all listed database drivers (oracledb, pymysql, psycopg2, pymssql, ibm_db_dbi, pyodbc, jaydebeapi, sqlite3, teradata).
- Performance characteristics when handling large result sets or frequent queries in test suites.
What it is and what it does
This is a Robot Framework library that extends the framework with keywords for database operations, allowing test suites to connect to, query, and verify data in databases. It wraps Python database modules (like oracledb, pymysql, or psycopg2) and exposes keywords for executing SQL queries, checking row counts, validating query results, and managing multiple simultaneous database connections via aliases.
The library is designed for test automation scenarios where you need to verify database state or content as part of your test execution. It handles connection setup, query execution, and result validation through Robot Framework's keyword syntax, making it natural to use within Robot Framework test cases and keywords. You supply the database driver module separately, and the library provides the glue to use it within your tests.
Use it for
- Verify database records after an application operation in an automated test suite.
- Check row counts or specific values in database tables as part of test assertions.
- Test data setup and teardown by executing SQL commands from Robot Framework tests.
- Validate data consistency across multiple databases in a single test run using connection aliases.
- Query and assert on database state without writing custom Python code in your test suite.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you are using Robot Framework for test automation and need to query or verify databases.
Install friction is low and the library is permissively licensed. Maintenance is aging (last release 213 days ago), so verify that your target database driver is supported before committing; no known vulnerabilities are present. Suitable for teams already invested in Robot Framework who want database testing without custom code.
Install
robotframework-databaselibrary on PyPI
Before you install
Low install friction with a pure-wheel distribution. Maintenance status is aging—last release was 213 days ago—but the repository remains active and has not been archived.
Requires a separate Python database module (e.g., oracledb, pymysql, psycopg2) to be installed separately depending on your target database.
License in practice
Licensed under Apache License 2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions.
Quickstart
pip install robotframework-databaselibrary
*** Settings ***
Library DatabaseLibrary
*** Test Cases ***
Query Database
Connect To Database oracledb db_name=db db_user=user db_password=pass db_host=127.0.0.1 db_port=1521
${rows}= Query select FIRST_NAME from person
Should Be Equal ${rows}[0][0] Franz AllanVerify before relying
- Whether the library actively maintains compatibility with all listed database drivers (oracledb, pymysql, psycopg2, pymssql, ibm_db_dbi, pyodbc, jaydebeapi, sqlite3, teradata).
- Performance characteristics when handling large result sets or frequent queries in test suites.
Package facts
| License | Apache License 2.0 permissive |
| Python support | Supports the current Python release >=3.8.1 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagesrobotframeworkrobotframework-assertion-enginesqlparse |
| Maintenance | Aging 213 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 392,715 / month, #7,006 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3 |
Evidence: robotframework_databaselibrary-2.4.1-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “robot framework database testing”
- robotframework-databaselibraryA Robot Framework library that adds keywords for querying databases,…
- robotframework-datadriverDataDriver extends Robot Framework to generate multiple test cases…
- robotframework-fakerWraps Faker's random test data generation as Robot Framework…
Give your agent the search over MCP, or paste the wish link into any chat.
More Testing packages
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
virtualenv creates isolated Python environments where packages can be installed independently without affecting the system Python or other projects.
Coverage.py measures which lines of Python code are executed during test runs, reporting coverage percentages and identifying untested code paths.
Install it if you want to measure test completeness or enforce coverage thresholds in your project.
pytest-asyncio is a pytest plugin that enables writing and running async test functions using the asyncio library, allowing developers to await code directly within test cases.
Install it if you write tests for any asyncio-based code.
A pytest plugin that generates test reports in Common Test Report Format (CTRF) as JSON, compatible with pytest-xdist and pytest-playwright for distributed and browser-based testing.
Install it if you need CTRF-formatted test output for CI/CD integration or cross-tool reporting.
See also robotframework-assertion-engine · robotframework-seleniumlibrary · robotframework-csvlibrary · robotframework-faker · robotframework-appiumlibrary · robotframework-excellib · robotframework-dependencylibrary · robotframework-pythonlibcore · robotframework-imaplibrary2 · robotframework-requests